hi all, this is what i got:
SELECT find_in_set( box, '2,3,4,5,6,12' ) <1 AS YESNO, box FROM f2g_booking ORDER BY box what i need is those values that haven't been found from the find_in_set list. f2g_booking holds box values of 1,2,4,5,12, that means that are no entries with 3 and 6 in the table... that's what i need 3 and 6 as a result, e.g. those values from the list that haven't been found (are not in the table). how to do that? thanks: lars