Introduction

In this article, we will learn how to use AND, OR, NOT operators with a SQL select query.

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

To filter records and extract only those records that fulfill a specified condition, The WHERE clause is used.

 

The AND Operator

• The AND operator is used, to filter records based on more than one WHERE condition.
• If all the conditions separated by AND are TRUE, The AND operator displays records.

Syntax

SELECT column1, column2, ...columnN
FROM TABLE_NAME
WHERE condition1 AND condition2 AND condition3 AND ...conditionN;

Example

The subsequent statement would return data of all available fields in the Article table (Only those records that fulfill a specified condition).

SELECT * FROM Article 
WHERE Id = 'A2' AND Title = 'Concept of SQL';

 

The OR Operator

• The OR operator is used, to filter records based on more than one WHERE condition.
• If any of the conditions separated by OR is TRUE, The OR operator displays records.

Syntax

SELECT column1, column2, ...columnN
FROM TABLE_NAME
WHERE condition1 OR condition2 OR condition3 OR ...conditionN;

Example

The subsequent statement would return data of all available fields in the Article table (Only those records that fulfill a specified condition).

SELECT * FROM Article 
WHERE Title = 'Introduction' OR Title = 'Concept of SQL';

 

The NOT Operator

• If the WHERE condition(s) are NOT TRUE, The NOT operator displays a record.

Syntax

SELECT column1, column2, ...columnN
FROM TABLE_NAME
WHERE NOT condition;

Example

The subsequent statement would return data of all available fields in the Article table (Only those records that not fulfill a specified condition).

SELECT * FROM Article 
WHERE NOT Title = 'Introduction';

 

Also, check How To Use Where Condition With Select Query In SQL