Is it possible to do something like this:
SELECT * FROM releases WHERE labels NOT INTERSECT $exludeList
The labels fields are strings with four integers. Ie. "1, 34, 73, 66"
Thanks for reading. :)
I think you need "not in" rather than intersect
SELECT * FROM releases WHERE labels NOT IN ('1', '34','73','66');
Thanks for the swift reply. Won't that return a false if the label is "1,3,6" and the exclude list is "1,2,3,4,8,9"?
I mean in this example the string "1,3,6" is not to be found in the exclude list.