We started learning about regular expressions by reproducing the LIKE
operator and all it’s features (wildcards for a single character and for the beginning/end of text).
In this lesson let’s do the same and implement something similar to the ILIKE
operator.
How can we achieve case insensitive matching with regular expressions? Here’s a virtual table for you to play with:
WITH strings AS ( SELECT 'foobar' AS string UNION SELECT 'FOOBAR' AS string UNION SELECT 'fooBAR' AS string ) SELECT string FROM strings
Think about it for a couple of minutes...
Sign up and check out 36 free lessons and exercises.
About SQL Habit
Hi, it’s Anatoli, the author of SQL Habit. 
SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst
and solve real-life challenges from Business, Marketing, and Product Management.
SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 