Code to find all database fields starting with letter a or b

is there php code or a swl query that will allow you to pull database fields that only begin with a certian letter?

 

Possibly something like:

SHOW COLUMNS FROM table;

Not sure if the conditional will work... Requires MySQL 5.0.3 and up...

SHOW COLUMNS FROM table WHERE Field LIKE 'A%';

I do know that you cannot sort be names. You may have to program that into your code's logic.

Also this may help some: http://se2.php.net/manual/en/function.mysql-fetch-field.php

 

what do you mean cannot sort by names?

 

For a SHOW COLUMNS Query, sorting isn't allowed, (IE: SHOW COLUMNS FROM table ORDER BY Field ASC).