IN Keyword
The IN keyword is used to check multiple values in a where clause.
When you want to give a condition based on multiple values, then the In Operator is used.
The IN operators behave the same as the OR operators.
Syntax
SELECT <COLUMNS> FROM <TABLE_NAME>
WHERE <COLUMN_NAME> IN (<VALUE1>,<VALUE2>,<VALUE3>);
Example
SELECT * FROM Employee
WHERE Emp_Dept IN ('IT', 'Finance', 'Purchase');
Summary
In a where clause, the IN keyword is utilised to check multiple values.