mysql AND operator

UK [ənd] US [ənd, ən,ænd]

conj.And; and, with; so, then; therefore

mysql AND operator syntax

Function:Combine two or more conditions in the WHERE substatement.

Syntax:SELECT * FROM table name WHERE field 1 operator value AND field 2 operator value

Description:If the first condition and the second condition are true, the AND operator displays a record. If one condition is not met, null

is returned.

mysql AND operator example

//显示所有姓为 "Carter" 并且名为 "Thomas" 的人 SELECT * FROM Persons WHERE FirstName='Thomas' AND LastName='Carter';