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

Example:

SELECT * FROM employee
WHERE emp_LastName IN ('james','jones')

---