WHERE and filtering

WHERE filters rows so a query only returns the ones that match a condition. Combine conditions with AND / OR, and use operators like =, >, LIKE, IN, and BETWEEN.

SELECT * FROM users WHERE age >= 18;

SELECT name, email FROM users
WHERE age >= 18 AND city = 'Dallas';

SELECT * FROM products WHERE category IN ('books', 'games');

SELECT * FROM products WHERE price BETWEEN 10 AND 50;

-- % matches any characters
SELECT * FROM users WHERE email LIKE '%@gmail.com';

SELECT * FROM users WHERE phone IS NULL;