IN

The operator expresses filtering between several conditions. It is an alternative to OR.

Structure:

SELECT column_name
FROM table_name
WHERE column_name IN pattern;

Or used for subselect:

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

 

Example1:

We have a table Customer with this data:

 

SELECT name
FROM Customer
WHERE hair IN ('blonde', 'brown');

 

We can also write it in this longer form:

SELECT name
FROM Customer
WHERE hair = 'blonde' or hair = 'brown';

 

Example2:

SELECT name
FROM Customer
WHERE hair NOT IN ('blonde', 'brown');

 

Example3:

SELECT name
FROM Customer
WHERE hair IN (SELECT name FROM Employees );

Thor is also in the Customer table and the Employees table.

We have a table Customer with this data:

 

Table Employee:

 

Here is Select result: