I have a field in the table, call it 'stuff', and it contains a list of values that are comma separated. i.e. 'Books,DVDs,Video Tapes,CDs'
I want to SELECT out all records that have an item. I know IN works the other way, so is there something that will get what I want like this: SELECT * FROM Inventory WHERE stuff CONTAINS 'Books' ORDER BY name I appreciate any help. Dale Hans -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]