Summary
The quantified LIKE operator, now available, eases writing queries comparing a field value to multiple patterns. It uses three quantifiers: ANY, SOME, and ALL. ANY and SOME are true if one pattern matches the field value. ALL requires the field to match all patterns. For example, 'page_path LIKE "%blog%" AND page_path LIKE "%luka%"' becomes 'page_path LIKE ALL ("%blog%", "%luka%")'.