The MySQL IN operator helps you to reduce the use of multiple OR conditions in a SELECT, INSERT, UPDATE, or DELETE statement.
To reduce the use of multiple OR conditions, use the following syntax:
Parameters:
expression : The specified value to test.
value1, value2: Values to test against expression.
Note:
In the above example, we are performing IN operator to test the multiple values against expression.
You can use MySQL Command Line Client to perform In operator to test multiple values against expression. It will look like this: