MySQL IN Operator

 

IN Operator Examples

The following SQL statement selects all customers that are located in "Germany", "France" or "UK":

SELECT * FROM Customers
WHERE Country IN ('Germany', 'France', 'UK');

SELECT * FROM Customers
WHERE Country NOT IN ('Germany', 'France', 'UK');

SELECT * FROM Customers
WHERE Country IN (SELECT Country FROM Suppliers);

SELECT * FROM Employee

WHERE SALARY =  ( SELECT MAX(Salary) from Employee);