Lesson 7.3 · Pro
Pattern matching and whole words
Search text with LIKE, ILIKE and regular expressions, including matching a whole word only.
In this lesson
- LIKE and ILIKE recap
- Regular expressions with ~ and ~*
- Match a whole word with \m and \M
- Rows that don't match
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.