SQLite IN

The SQLite IN operator is used to check if a given value is contained within a set of values.
When you run a query with the IN operator, the given column will be checked and if at least one value from the set of values is found, then the query will one or more records.

Syntax

The SQLite IN syntax is as follows:

SELECT column_name1, column_name2, ...
FROM table_name
WHERE column_name IN (set_of_values);

Example

Table of student_address

address_id	city	country
100	San Antonio	US
101	San Jose	US
102	Philadelphia	US
103	Austin	US
104	Boston	US
105	Seattle	US

In the first example, the select returns records from the student_address table, if the address_id column will have values included in the given set.

SELECT * FROM student_address WHERE address_id IN (101,102);

Output

address_id	city	country
101	San Jose	US
102	Philadelphia	US

The second example is similar to the first, the difference is that the city column will be checked. If at least one value from the set of values is found in the city column, then the select will return at least one record.

SELECT * FROM student_address WHERE city IN ('Boston','Seattle');

Output

address_id	city	country
104	Boston	US
105	Seattle	US