Is there a simple function or method to compare a value in a column to one or more items in a comma separated list?
select * from table where value <contains one of> ('apple','orange','banana');
and say value may = something like 'produce(grape,orange,pear,apple,lettuce)'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
