MySQL List Set theory, relational database
SELECT business.name FROM business WHERE (3) NOT IN (1,2,3)
The above is a valid MySQL statement. But I need a statement which allows
the NOT IN condition to work with 2 lists i.e. none of the elements in the
first list appear in the second.
E.g.
SELECT business.name FROM business WHERE (4, 5) NOT IN (1,2,3)
Note: These lists are integer values and are generated using nested queries
Thank You in advance
No comments:
Post a Comment