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';