GAQL: Escape % and _ in LIKE

[FW API]

Hi.

I would like to use % and _ literally in a LIKE filter.

How can I escape these special characters?

Does GAQL LIKE use other special characters besides these two?

Thanks.

[Google Ads API Forum Advisor]

Hi there,

Thanks for reaching out to the Google Ads API Forum.

You may note that to match a literal [, ], %, or _ using the LIKE operator, surround the character in square brackets. For example, the following condition matches all campaign.name values that start with [Earth_to_Mars]:

• campaign.name LIKE '[[]Earth[_]to[_]Mars[]]%'

The LIKE operator can only be used on a string field, not an array.

Let me know if you have any questions. 

This message is in relation to case "ref:_00D1U1174p._5004Q2mBBLh:ref"

Thanks,
 

Google Ads API Team