Published Jun 11, 2021Updated Aug 18, 2022
Contribute to Docs

The IN operator allows the user to specify multiple values in the WHERE clause.


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 (

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:

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:

FROM customers
WHERE country IN (
SELECT country
FROM suppliers

All contributors

Looking to contribute?

Learn SQL on Codecademy