MySQL WHERE Clause

The WHERE clause filters the rows. Only the rows where the condition is true are returned.

SELECT * FROM students WHERE marks > 80;

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

Text values are written in single quotes. Numbers are not.

---

Comparison operators

Operator	Meaning
=	Equal
<> or !=	Not equal
>, <	Greater than, less than
>=, <=	Greater or equal, less or equal
BETWEEN	In a range
LIKE	Matches a pattern
IN	Matches any value of a list
IS NULL	Has no value

SELECT name, marks FROM students WHERE marks <= 65;

---

WHERE with UPDATE and DELETE

The same WHERE is used in UPDATE and DELETE, to choose which rows to change. It is very important there.

---

Summary

• WHERE condition returns only matching rows.
• Use quotes for text and no quotes for numbers.
• Next: AND, OR and NOT.

• Previous Page
• Next Page

---

Exercises & Assignments
No Content Found.

Interview Questions & Answers
No Content Found.