MySQL AND, OR and NOT

To use more than one condition in WHERE, join them with AND, OR and NOT.

Operator	Row is returned when
AND	Both conditions are true
OR	At least one condition is true
NOT	The condition is not true

AND

SELECT name, city, marks FROM students
WHERE city = 'Mumbai' AND marks > 50;

Neha is in Mumbai too, but her marks are 45, so she is not returned.

---

OR

SELECT name, city FROM students
WHERE city = 'Delhi' OR city = 'Pune';

---

NOT

SELECT name, city FROM students
WHERE NOT city = 'Delhi';

---

Use brackets

AND is checked before OR. Use brackets to make your meaning clear.

SELECT name, city, marks FROM students
WHERE (city = 'Delhi' OR city = 'Mumbai') AND marks >= 70;

---

Summary

• AND needs both, OR needs one, NOT reverses.
• Use brackets when you mix AND and OR.
• Next: ORDER BY.

• Previous Page
• Next Page

---

Exercises & Assignments
No Content Found.

Interview Questions & Answers
No Content Found.