IN/NOT IN

The IN operator is used to compare multiple values in the where clause. For example, the following query is used to find all users that have city either new york or chicago:

select * from users where city IN ('new york','chicago')

NOT IN works in reverse, for example, find all users that do not have city either new york or chicago:

select * from users where city NOT IN ('new york','chicago');