# The WHERE Clause

The WHERE Clause: The WHERE Clause: an overview, Types of Filters, Using Multiple Condition Filters.

Updated: November 16, 2026

1. [The WHERE Clause: an overview](https://www.ask-codey.com/lessons/the-where-clause-an-overview) (Novice): Add a WHERE clause to return only the rows that match a condition, such as customers in the UK.
2. [Types of Filters](https://www.ask-codey.com/lessons/the-where-clause-types-of-filters) (Apprentice): Filter numbers and dates with comparison operators, and text with LIKE and its % and \_ wildcards.
3. [Using Multiple Condition Filters](https://www.ask-codey.com/lessons/the-where-clause-using-multiple-condition-filters) (Apprentice): Combine conditions in a WHERE clause with AND and OR, and use parentheses so they're checked the way you mean.

Source: https://www.ask-codey.com/courses/java-full-stack-bootcamp/topics/the-where-clause
