IN
Published Jun 11, 2021Updated Aug 18, 2022
Contribute to Docs
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);
Contribute to Docs
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.
Learn SQL on Codecademy
- Skill path
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.Includes 9 CoursesWith CertificateBeginner Friendly17 hours - Skill path
Design Databases With PostgreSQL
Learn how to query SQL databases and design relational databases to efficiently store large quantities of data.Includes 5 CoursesWith CertificateBeginner Friendly13 hours - Free course
Learn SQL
In this SQL course, you'll learn how to manage large datasets and analyze real data using the standard data management language.Beginner Friendly5 hours