SQL AND, OR and NOT operators

The SQL AND, OR and NOT operators

 

These are operators which are can use with WHERE statement.

 

AND and OR operators are used to filter records based on more thatn one condition

- The AND operator displays a record if all the conditions separated by AND are TURE

- The OR operator displays a record if any of the conditions seprated by OR is TURE

 

THE NOT operator displays a record if the condition(s) is NOT TURE.

 

That meas 

if statements goes like this

~~~where City = "LONDON" and "SEOUL"  

 

the column values has to have 'LONDON', "SEOUL", if the columns doesn't have both of that, it could't display.

However if use OR, and the column has one of them, it will show you something