Re: How to select records if any of it's fields match the requirement?

[Justin Patrin <papercrane@xxxxxxxxxxxxxxx>]

Amanda wrote:
> I would like to select the records where any of the fields LIKE '%abc%'
>
> Can I do that without knowing the table's column names?
>
>  
>
> If table column names are required, how can I retrieve the column names from
> the table? 
>
>  
>
> Regards
>
> Amanda

Many database engines will give them to you if you do this:

DESCRIBE table;

--
paperCrane <Justin Patrin>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php