Posted by Virginner on 09/27/07 10:26

<tom@thumb.com> wrote in message
news:MPG.21619aec8b216c7e9899cc@news-text.blueyonder.co.uk...
>
> Thats field not table -
>
> I just want to see if a particular field exists in a specified table and
> for the method to work reliably on as many mySQL versions as possible.
>
> Obviously the most efficient would be best - I can't see anything in the
> mySQL docs to do this. Did I miss it?
>
> thanks.
>
> Tom.

SHOW FIELDS FROM tablename LIKE 'fieldname'

• Next in forum: How to select fields form two tables, where one is containing some text+field form other table+some text
• Prev in forum: Re: Compare every word in paragraph with every row in database
• Thread view: Re: Whats the most portable way to identify field existence?

[Reply to this message]