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_name
WHERE column_name IN (value1, value2, ...);

You can also use another returned result within the parenthesis:

SELECT column_name(s)
FROM table_name
WHERE 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_city
FROM movies
WHERE 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 inventory
WHERE 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 customers
WHERE country IN (
SELECT country
FROM suppliers
);

Contributors

Interested in helping build Docs? Read the Contribution Guide or share your thoughts in this feedback form.

Learn SQL on Codecademy