The AND operator allows the existence of multiple conditions in an SQL statement’s WHERE clause. Gives TRUE if all the conditions separated by AND is TRUE.
Syntax:
SELECT * FROM table_name WHERE condition1 AND condition2 and ...conditionN;
table_name: name of the table
condition1,2,..N : first condition, second condition and so on