Posted by Oak Hall on 09/27/05 21:33

thanks will use that

"Oli Filth" <catch@olifilth.co.uk> wrote in message
news:nuf_e.624$Nv6.443@newsfe6-win.ntli.net...
> 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]