The WHERE clause lets you specify conditions to filter rows.
Comparison Operators
| Operator | Meaning |
|---|---|
| = | Equal to |
| != or <> | Not equal to |
| > | Greater than |
| < | Less than |
| BETWEEN | Between a range |
| LIKE | Pattern matching |
| IN | Match any in a list |
Lesson 6 of 22 · SQLite
Filtering with WHERE
Filter rows with SQL WHERE, comparison operators, IN, LIKE and BETWEEN.
Your challenge
Find every crime report from Chicago or Boston.
Solve it in your browserFree, no sign-up. The SQLite database runs in your browser; your answer is checked instantly, with hints if you need them. Plus a 2-question quiz.