AND & OR Operators

AND OR Example

Have a table

Name	Age	City
Bob	10	Paris
Mat	20	Berlin
Mary	24	Prague

select Name from table where Age>10 AND City='Prague'

Gives

Name
Mary

select Name from table where Age=10 OR City='Prague'

Gives

Name
Bob
Mary

Syntax

SELECT * FROM table WHERE (condition1) AND (condition2);

SELECT * FROM table WHERE (condition1) OR (condition2);