MySQL – AND

An AND condition is used with SELECT, INSERT, UPDATE, and DELETE statements to test two or more conditions simultaneously.

Syntax:

WHERE condition1  
AND condition2  
...  
AND condition_n; 

condition1, condition2, … condition_n – This section specifies all the conditions that must be met in order to select records.

Example:

SELECT *  
FROM   employees
WHERE last_name = 'Sluis'  
AND emp_no > 1;