`WHERE` limits the rows returned based on a condition. Where statements are used in both DML and DDL. `WHERE` supports `>`, `<`, `=`, `!=`, `>=`, `<=`, the boolean operators, `BETWEEN` and `LIKE`. # boolean operators Link multiple conditions with `AND`, `OR`. Use parentheses to define (and communicate to others) the order of operations. # between Use `BETWEEN` with `AND` like `BETWEEN '2025-01-01' AND '2025-01-31' . Note that between is inclusive. # like `LIKE` allows for fuzzy matching of character strings. Use the wildcard `%` to represent any number of any character and `_` to represent exactly one character. Match string should be wrapped in single quotes.