Welcome to RegexHabit!
Let’s start learning regular expressions syntax by doing something we already know how – matching a string pattern in the beginning/middle or the end of the text value. Basically, we’re implementing the
ILIKE operators with regular expressions.
Once again, let’s put together a quick virtual table so we can practice regular expressions in a safe and predictable environment:
WITH marketing_campaigns AS ( SELECT '20180120-us_ca_au_gb-mf-best_reading_service' AS utm_campaign UNION SELECT '20180204-de-m-mens_health'...