Maintained with ☕️ by
IcePanel logo

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

Share

Services

## Feature The [quantified LIKE operator](https://cloud.google.com/bigquery/docs/reference/standard-sql/operators#like%5Foperator%5Fquantified) is [generally available (GA)](https://cloud.google.com/products#product-launch-stages). 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 for `LIKE ANY`. * `LIKE ALL`: Checks if every pattern matches.