Alex Rivera | Logout

How to implement "like" in BigQuery?

Asked 2012-10-11T01:38:29.750
15

I am trying to run a simple query making a restriction of like % in BigQuery, but LIKE is not in their syntax, so how can it be implemented?

google-bigquery
Edit
Report

1 Answer

7

REGEXP_MATCH returns true if str matches the regular expression. For string matching without regular expressions, use CONTAINS instead of REGEXP_MATCH.

https://developers.google.com/bigquery/docs/query-reference#stringfunctions

answered 2013-04-28T19:33:11.803

Your Answer