AND
The AND command is used with WHERE to only include rows where both conditions is true.
The following SQL statement selects all fields from “Customers” where country is “Germany” AND city is “Berlin”:
Example
SELECT * FROM Customers
WHERE Country='Germany' AND City='Berlin';