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.