The solution to my specific problem, i.e. matching using substrings, is to use:
LIKE "%<thesubstring>%". To note the double quotes and the % around <thesubstring>, which is of course just a placeholder for your actual substring. I found this info here: https://chartio.com/resources/tutorials/how-to-implement-sqls-like-operator-in-google-bigquery/, which also contains other useful info. On Thursday, March 16, 2023 at 10:53:26 AM UTC+1 Nelson Brochado wrote: > Hi. > > I've never used the LIKE operator to filter the content of a query. I > think that's what I need, but I'm not sure because I can't find a > documentation page that describes it well with examples. Here > <https://developers.google.com/google-ads/api/docs/query/grammar#rules> we > have some info, but that's not useful. > > So, where can I find the documentation on the LIKE operator? I suppose > this operator is used with a regular expression, but there's also > REGEXP_MATCH, > so that guess is probably wrong. Nevertheless, it seems to accept some > special characters, like ], [, % > > If there's no documentation on it, can you just explain to me how to use > it in all cases? > > Of course, I understand it's used to compare some resource with some > string (e.g. to check if a campaign name starts with some string). Well, > that's fine, but that's not enough for me to understand if I can use this > LIKE operator to match any substring, what the purpose of it really is, > and, more importantly, how to use it correctly. > > Thanks for the help. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/cf69b634-6fee-4e88-a881-b4768183e290n%40googlegroups.com.
