IN and BETWEEN Operators

Instead of writing multiple OR conditions, SQL provides cleaner alternatives.

IN - Match Any Value in a List

SELECT * FROM users WHERE city IN ('New York', 'Boston', 'Chicago');

This is equivalent to:

SELECT * FROM users WHERE city = 'New York' OR city = 'Boston' OR city = 'Chicago';

BETWEEN - Match a Range

SELECT * FROM users WHERE age BETWEEN 25 AND 35;

This is equivalent to:

SELECT * FROM users WHERE age >= 25 AND age <= 35;

Note: BETWEEN is inclusive on both ends.

Exercises

When to Use Each

Use Case	Operator
Matching multiple specific values	IN
Matching a continuous range	BETWEEN
Excluding specific values	NOT IN
Excluding a range	NOT BETWEEN

Free Practice