MySQL AND Operator
The AND operator is a logical operator that combines two or more Boolean expressions and returns true only if both expressions evaluate to true. The AND operator returns false if one of the two expressions evaluate to false.
Here is the syntax of the AND operator:
SELECT
customername,
country,
state
FROM
customers
WHERE
country = 'USA' AND state = 'CA';