Closed github-actions[bot] closed 7 months ago
The quantified LIKE operator is generally available (GA). With this operator, you can check a search value for matches against a list of patterns or an array of patterns, using one of these conditions:
LIKE
LIKE ANY
LIKE SOME
LIKE ALL
https://cloud.google.com/bigquery/docs/release-notes#April_18_2024
Feature
The quantified
LIKE
operator is generally available (GA). With this operator, you can check a search value for matches against a list of patterns or an array of patterns, using one of these conditions:LIKE ANY
: Checks if at least one pattern matches.LIKE SOME
: Synonym forLIKE ANY
.LIKE ALL
: Checks if every pattern matches.https://cloud.google.com/bigquery/docs/release-notes#April_18_2024