MYSQL AND OR NOT operators

• AND operator display only those records where all the given conditions are true.
• OR operator displays only those records where at least one or more conditions are true.
• NOT operator display records where a condition is not true.

To understand these operators, we will use the given table as an example.

AND operator

Fetch all those records which have a price greater than 1000 and qty less than 2.

SELECT * FROM products WHERE price > 1000 AND qty < 2;

OR Operator

Fetch all those records which have a qty greater than 1 or the total is less than 1000.

SELECT * FROM products WHERE qty > 1 OR total < 1000;

NOT Operator

Fetch all those records which does not have product_name "Pen"

 SELECT * FROM products WHERE NOT product_name="Pen"