IN allows you to specify multiple values in a WHERE clause. Cleaner than multiple OR conditions.

Basic IN Syntax

SELECT * FROM table WHERE column IN (value1, value2, value3);

IN with Strings

SELECT * FROM customers WHERE country IN ('USA', 'Canada', 'UK');

IN with Numbers

SELECT * FROM products WHERE category_id IN (1, 2, 3, 4);

NOT IN

SELECT * FROM orders WHERE status NOT IN ('cancelled', 'refunded');

IN with Subquery

SELECT * FROM products

WHERE category_id IN (SELECT id FROM categories WHERE active = true);

IN vs Multiple OR

-- Using IN (preferred)

SELECT * FROM customers WHERE country IN ('USA', 'UK', 'Canada');

-- Using OR (verbose)

SELECT * FROM customers

WHERE country = 'USA' OR country = 'UK' OR country = 'Canada';

Generate IN Queries

AI2sql automatically uses IN for multiple value conditions.