From: "Robb Kerr" <[EMAIL PROTECTED]>
> I've inherited a database so must live with a less than elegant structure.
> The table contains one "keyword" field into which the author has entered
> things like...
>
> Record 1 = Apples
> Record 2 = Apples, Bananas
> Record 3 = Apples, Figs
> Record 4 = Bananas, Figs, Dates
>
> I need to do a search on this field to return all of the records
containing
> "Figs". What's the search syntax?
SELECT * FROM table WHERE FIND_IN_SET('Figs',fieldname)
---John Holmes...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
