IN
The IN
operator allows the user to specify multiple values in the WHERE
clause.
Syntax
The IN
operator is similar to multiple OR
conditions:
SELECT column_name(s)FROM table_nameWHERE column_name IN (value1, value2, ...);
You can also use another returned result within the parenthesis:
SELECT column_name(s)FROM table_nameWHERE column_name IN (SELECT STATEMENT);
Example 1
The given query will select all records where production_city
is equal to 'Los Angeles'
or 'New York'
.
SELECT production_cityFROM moviesWHERE production_city IN ('Los Angeles', 'New York');
Example 2
To query all fields for records where item_name
is equal to 'plunger'
, 'soap'
, or 'wipes'
in the inventory
table:
SELECT *FROM inventoryWHERE item_name IN ('plunger', 'soap', 'wipes');
Example 3
The following SQL statement selects all customers that are from the same countries as the suppliers:
SELECT *FROM customersWHERE country IN (SELECT countryFROM suppliers);