Day 4 of 14 30 minAND / ORINLIKENULL
Ask precise questions. Combine conditions with AND, OR and NOT, match lists and ranges with IN and BETWEEN, search text with LIKE, and handle NULL correctly.
By the end of today you can
- Combine conditions with AND, OR, NOT and parentheses
- Use IN and BETWEEN for lists and ranges
- Search text patterns with LIKE and ILIKE
- Find missing values with IS NULL, and understand why = NULL never matches
- Replace missing values with COALESCE
What's inside
- 5 sections
- 3 diagrams and mind maps
- 6 code examples you can run
- 5-question quiz
- 1AND, OR, NOT
- 2IN and BETWEEN
- 3Text patterns: LIKE and ILIKE
- 4NULL: the missing value
- 5COALESCE: a default for missing values
Sign in free to read this lesson
Get the full lesson with diagrams, runnable code and the quiz. Your progress is saved across devices.
Sign in free