MySQL IN Condition
The MySQL IN condition used to reduce the use of multiple OR conditions in a SELECT, INSERT, UPDATE and DELETE statement.
MySQL IN syntax
expression IN (value1, value2, .... value_n);
MySQL IN Example
SELECT *
FROM army
WHERE rank IN ('bsf', 'commandor', 'leptinant');