The SQLite IN operator checks whether a value is contained by the return value of a subquery or by a list of values.
The syntax looks like this:
expression IN subquery;
Or like this:
expression IN valuelist;
Here is a SQLite SELECT query example that makes use of the IN operator:
SELECT name FROM suppliers WHERE machinetype IN (4,5,8,10);
Above SQLite SELECT query will return all supplier names of suppliers that possess machines of types 4, 5, 8, or 10.