MySQL WHERE clause is used to filter the result based on a specified condition. 

S. No.TitleSyntex
1Simple Equality ConditionSELECT *  FROM employees  WHERE department = 'IT'; 
 
2 Inequality ConditionSELECT *  FROM employees  WHERE salary != 50000; 
 
3Range ConditionSELECT *  FROM employees  WHERE salary BETWEEN 40000 AND 60000; 
 
4Pattern Matching with LIKESELECT *  FROM products  WHERE product_name LIKE '%Widget%'; 
 
5 Combining ConditionsSELECT *  FROM employees  WHERE salary > 50000 AND department = 'IT'; 
 
6NULL CheckSELECT *  FROM employees  WHERE manager IS NULL;