MySQL IN

The IN operator allows you to specify multiple values in a WHERE clause.

Syntax:

SELECT column_name(s)FROM table_name WHERE column_name IN (value1,value2,…);

Ex:

SELECT * FROM Customers WHERE salary IN (5000, 10000);