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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
