Re: Keyword Search
| From: | John W. Holmes | Date: | Tue, 06 Apr 2004 19:21:07 +0000 |
| Subject: | Re: Keyword Search | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-182527@lists.php.net to get a copy of this message | ||
From: "Robb Kerr" <rkerr@digitaliguana.com>
> 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...