Re: How to select records if any of it's fields match the requirement?
| From: | Justin Patrin | Date: | Sat, 22 May 2004 02:41:32 +0000 |
| Subject: | Re: How to select records if any of it's fields match the requirement? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34525@lists.php.net to get a copy of this message | ||
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 AmandaMany database engines will give them to you if you do this: DESCRIBE table; -- paperCrane <Justin Patrin>