SQLearnAcademy

← Learn/Part 1 · Query basics

Module 02

Filtering data: WHERE

You rarely need every row at once. WHERE is a filter that keeps only the products matching a condition. Here you'll master comparisons, logic, ranges, lists, pattern search, and working with NULL.

0 / 8 lessonsStart module

Lessons8 lessons

  1. 01

    Now

    WHERE: keeping only the rows you need

    The electronics-department manager wants to see only their own products, not the whole store. You need to keep only the rows in the 'Electronics' category.

    Start
  2. 02Comparison operators
  3. 03AND, OR, NOT: complex conditions
  4. 04BETWEEN: ranges of values
  5. 05IN: a list of values
  6. 06LIKE: pattern search
  7. 07IS NULL: filtering empty values
  8. 08Parentheses and condition precedence