SELECT and Filtering

SELECT and Filtering in MySQL

SELECT * FROM products WHERE price > 50;
SELECT * FROM users WHERE status = 'active';
SELECT * FROM orders WHERE created_at >= '2024-01-01';

SELECT * FROM products
WHERE price > 10 AND price < 100;

SELECT * FROM users
WHERE role = 'admin' OR role = 'moderator';

SELECT * FROM users WHERE id IN (1, 3, 5, 7);
SELECT * FROM products WHERE category NOT IN ('food', 'drink');

SELECT * FROM products WHERE price BETWEEN 20 AND 80;
SELECT * FROM orders WHERE created_at BETWEEN '2024-01-01' AND '2024-12-31';

SELECT * FROM users WHERE email LIKE '%@gmail.com';
SELECT * FROM products WHERE name LIKE '%phone%';

Pro Tip

LIKE '%text%' is case-insensitive in MySQL by default with utf8 collation.