SQL 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, ...);

Copy to clipboard
Copy to clipboard

You can also use another returned result within the parenthesis:

SELECT column_name(s)
FROM table_name
WHERE column_name IN (
  SELECT STATEMENT);

Copy to clipboard
Copy to clipboard

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');

Copy to clipboard
Copy to clipboard

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');

Copy to clipboard
Copy to clipboard

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
);

Copy to clipboard
Copy to clipboard