Keyword Search

From:	Robb Kerr	Date:	Tue, 06 Apr 2004 16:24:55 +0000
Subject:	Keyword Search
Groups:	php.general
Request:	Send a blank email to php-general+get-182491@lists.php.net to get a copy of this message

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? I've tried... SELECT * from dbname.tablename MATCH (dbname.fieldname) AGAINST 'Figs' It doesnt' work. Thanx in advance -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org