Filtering with WHERE

WHERE keeps only the rows that match a condition. It goes after FROM.

SELECT name, price
FROM products
WHERE price > 100;

Comparison operators

Note that SQL uses a single = for comparison.

Text values go in single quotes

SELECT name, city
FROM customers
WHERE country = 'India';

Text comparisons are case-sensitive in SQLite for =, so 'india' would find nothing.

Numbers don't

SELECT name, stock
FROM products
WHERE stock < 20;

Dates

Dates are stored as text in YYYY-MM-DD form, so they compare correctly as text:

SELECT order_id, order_date, status
FROM orders
WHERE order_date >= '2024-06-20';

Not equal

SELECT order_id, status
FROM orders
WHERE status <> 'delivered';