Filtering rows with WHERE

So far every query returned all the rows. Add a WHERE clause to keep only the rows that match a condition:

SELECT name, score FROM student WHERE score >= 80;

Only rows where the condition is true are returned.

Comparison operators

You can compare with:

• = equal to
• <> not equal to
• < less than, > greater than
• <= at most, >= at least

Numbers are written plainly (80). Text must go in single quotes ('11B'):

SELECT name FROM student WHERE form = '11B';

Common mistakes

• Text values go in single quotes: WHERE name = 'Ann'.
• WHERE comes after FROM.