MySQL + SQL · Lesson 46
WHERE Clause and Operators
The WHERE Clause
WHERE filters rows so a query returns only those that match a condition.
SELECT * FROM students WHERE marks >= 90;Only students with marks 90 or above are returned.
Operators You Can Use
| Operator | Meaning |
|---|---|
| = | equal to |
| != or <> | not equal |
| > < >= <= | comparisons |
| AND / OR / NOT | combine conditions |
Combined Conditions
SELECT name FROM students
WHERE class = '10' AND marks >= 80;
SELECT name FROM students
WHERE class = '9' OR class = '10';Summary
- WHERE filters rows by a condition.
- Use =, !=, >, <, and combine with AND/OR/NOT.