IN and BETWEEN

Filter with a list using IN and a range using BETWEEN.

IN filters values inside a list; BETWEEN filters values inside a range. IN is shorter than many = and OR.

SELECT name FROM products
WHERE price BETWEEN 10 AND 50;

BETWEEN includes both endpoints; 10 and 50 are in the result.

name is selected from products. WHERE keeps only the rows where price BETWEEN 10 AND 50 holds.

IN and BETWEEN — details

IN checks whether a value equals any value in a list. The list goes in parentheses, values separated by commas. It is cleaner than a long OR chain.

BETWEEN is for ranges: WHERE price BETWEEN 10 AND 50 includes both 10 and 50.

Select name and price from products where price is between 10 and 50.

Show example solution

SELECT name, price
FROM products
WHERE price BETWEEN 10 AND 50

IN list

SELECT name FROM customers
WHERE city____('İstanbul', 'İzmir');

Show answer

SELECT name FROM customers
WHERE city IN ('İstanbul', 'İzmir');