MySQL WHERE Clause: Filtering Data with Examples

The WHERE clause turns a table dump into an answer. It filters rows based on conditions, and combining its operators well is what separates a beginner from a confident analyst.

Key Points

• Comparisons: =, <>, >, <, >=, <= (WHERE salary > 50000)
• Combine conditions: AND, OR, NOT — control precedence with parentheses
• Ranges: WHERE order_date BETWEEN '2026-01-01' AND '2026-03-31'
• Lists: WHERE city IN ('Delhi', 'Noida', 'Gurgaon')
• Patterns: WHERE name LIKE 'A%' (starts with A), '%son' (ends with)
• NULLs need IS NULL / IS NOT NULL — never = NULL