SQL Operators

The WHERE clause can be combined with AND, OR, and NOT operators. 

The AND and OR operators are used to filter records based on more than one condition: 

The AND operator displays a record if all the conditions separated by AND are TRUE. 

The OR operator displays a record if any of the conditions separated by OR is TRUE. 

The NOT operator displays a record if the condition(s) is NOT TRUE. 

 

AND Syntax:

SELECT column1, column2, … 
FROM table_name 
WHERE condition1 AND condition2 AND condition3 …; 

OR Syntax:

SELECT column1, column2, … 
FROM table_name 
WHERE condition1 OR condition2 OR condition3 …; 

NOT Syntax:

SELECT column1, column2, … 
FROM table_name 
WHERE NOT condition; 

Query1:

SELECT * FROM `employees` WHERE last_name='SidouAND gender='F' 

Output:

AND Operator Example

Query 2:

SELECT * FROM `employees` WHERE last_name='Sidou' OR first_name='Mary' 

Output:

OR Operator Example

Query 3:

SELECT * FROM `employees` WHERE NOT year(hire_date)<2000 

Output:

NOT Operator Example

Tester Usage Tips:

  • Validate matching records with filtering boundary conditions