WHERE
command
Filters rows based on one or more conditions. Supports comparison, logical, LIKE, IN, BETWEEN, IS NULL.
Syntax
WHERE condition1 AND|OR condition2
Example
sql
-- Comparison operators
SELECT * FROM users WHERE age > 18;
SELECT * FROM users WHERE name = 'Alice';
-- Multiple conditions
SELECT * FROM products WHERE price BETWEEN 10 AND 50 AND active = 1;
-- Pattern matching
SELECT * FROM users WHERE email LIKE '%@gmail.com';
-- In list
SELECT * FROM posts WHERE status IN ('published', 'featured');
-- Null check
SELECT * FROM users WHERE deleted_at IS NULL;