Filtering with WHERE

The WHERE clause filters rows, returning only the ones that match a condition.

A basic filter

Combining conditions

Use AND to require both conditions, or OR to require at least one:

Comparison operators

• = equal to
• != or <> not equal to
• >, <, >=, <= greater/less than