← Back to All Lessons

WHERE Clause

SELECT * FROM users WHERE age > 25;
SELECT * FROM users WHERE name = 'Alice';
SELECT * FROM users WHERE age >= 18 AND age <= 30;
SELECT * FROM users WHERE city = 'NYC' OR city = 'LA';

LIKE (Pattern Matching)

-- % = any characters, _ = single character
SELECT * FROM users WHERE name LIKE 'A%';      -- Starts with A
SELECT * FROM users WHERE email LIKE '%@gmail%'; -- Contains @gmail
SELECT * FROM users WHERE name LIKE '_ob';       -- 3 chars ending in "ob"

IN & BETWEEN

-- IN: match any value in a list
SELECT * FROM users WHERE city IN ('NYC', 'LA', 'Chicago');

-- BETWEEN: range of values
SELECT * FROM users WHERE age BETWEEN 20 AND 30;

-- NOT
SELECT * FROM users WHERE city NOT IN ('NYC', 'LA');
SELECT * FROM users WHERE name NOT LIKE 'A%';

NULL Checks

SELECT * FROM users WHERE phone IS NULL;      -- No phone
SELECT * FROM users WHERE phone IS NOT NULL;   -- Has phone

✅ Quick Quiz

← Previous Next: Joins →