MySQL WHERE clause is used to filter the result based on a specified condition.
| S. No. | Title | Syntex |
| 1 | Simple Equality Condition | SELECT * FROM employees WHERE department = 'IT'; |
| 2 | Inequality Condition | SELECT * FROM employees WHERE salary != 50000; |
| 3 | Range Condition | SELECT * FROM employees WHERE salary BETWEEN 40000 AND 60000; |
| 4 | Pattern Matching with LIKE | SELECT * FROM products WHERE product_name LIKE '%Widget%'; |
| 5 | Combining Conditions | SELECT * FROM employees WHERE salary > 50000 AND department = 'IT'; |
| 6 | NULL Check | SELECT * FROM employees WHERE manager IS NULL; |