Posted by Oli Filth on 09/27/05 20:40

Oak Hall said the following on 27/09/2005 18:33:
> I have a several tables the primary index field name in different in each
> one, how do I query with a 'where "column 1" = 3' if I do not know the name
> of that column only that it is the first field?? Thanks
> Oak
>
>

Execute the following MySQL statement:

SHOW COLUMNS FROM table

(where 'table' is the name of the table in question).

The result-set will be a list of the columns from that table.

--
Oli

[Back to original message]