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 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';

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';