/    /  MySQL – IN

MySQL – IN

 

MySQL – IN

By using the MySQL IN condition, multiple OR conditions can be reduced in SELECT, INSERT, UPDATE, and DELETE statements.

Syntax:

expression IN (value1, value2, .... value_n);  

expression: It specifies the values that will be tested.

value1, value2, … or value_n: In order to test the expression, these values must be provided. In the event that any of these values match the expression, the IN condition evaluates to true. Here is a quick method for determining whether any of the values match the expression.

Example

SELECT *  
FROM employees  
WHERE last_name IN ('Peac', 'Facello', 'Piveteau');

in