Mysql SQL AND & OR operator

The and or operators are used to filter records based on more than one condition.

And or operators

And or can combine two OR more conditions in the WHERE substatement.

If both the first AND second conditions are true, the AND operator displays a record.

If either the first condition OR the second condition is true, the OR operator displays a record.

Original table (used in the example ):

LastName	FirstName	Address	City
Adams	John	Oxford Street	London
Bush	George	Th Avenue	New York
Carter	Thomas	Changan Street	Beijing
Carter	William	Xuanwumen 10	Beijing

AND operator instance

Use AND to show all people with the last name "Carter" AND the name "Thomas:

SELECT * FROM Persons WHERE FirstName='Thomas' AND LastName='Carter'

Result:

LastName	FirstName	Address	City
Carter	Thomas	Changan Street	Beijing

OR operator instance

Use OR to display all people with the last name "Carter" OR "Thomas:

SELECT * FROM Persons WHERE firstname='Thomas' OR lastname='Carter'

Result:

LastName	FirstName	Address	City
Carter	Thomas	Changan Street	Beijing
Carter	William	Xuanwumen 10	Beijing

Combine the and or operators

We can also combine and or (using parentheses to form a complex expression ):

SELECT * FROM Persons WHERE (FirstName='Thomas' OR FirstName='William')AND LastName='Carter'

Result:

LastName	FirstName	Address	City
Carter	Thomas	Changan Street	Beijing
Carter	William	Xuanwumen 10	Beijing