I have a field (cdfeature) that contains a list of comma seperated values. Example follows:
select item_id, cdfeature from cars where (101 in (cdfeature)); +---------+---------------------+ | item_id | cdfeature | +---------+---------------------+ | 320 | 101,104,106 | | 321 | 101,103,105,112 | | 323 | 101,103,105,112 | | 316 | 101,102,104,108,112 | | 345 | 101,102,104,108,112 | +---------+---------------------+ When I select only one value (ie, 101) the statement works. I need to be able to select based upon multinple IN statements. When I try this, the query returns an empty set. Example follows: select item_id, cdfeature from cars where (101 in (cdfeature)) and (112 in (cdfeature)); Empty set (0.00 sec) The above query should have, I think, returned records that had BOTH a 101 an a 112 in the cdfeature filed. Specifically, it should have returned records 321, 323, 316, 345. Somebody please help me out here!!! Don! --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php