LIKE ALL and LIKE ANY in BigQuery
Let's look at the quantified LIKE operator in BigQuery. Why quantified? , you'll ask.
So while the normal LIKE operator can be used to check just for one pattern, the quantified one (still in preview btw) can check the presence of one or all patterns...
datawise.dev2 min read