The Merchant Center Query Language lets you filter the returned data set with a number of different operators. When filtering on string values, the default case sensitivity of each operator plays an important part in correctly filtering your results.
| Operators | Case Sensitivity |
|---|---|
| = or != | Case sensitive |
| (NOT) IN | Case sensitive |
| (NOT) LIKE | Case sensitive |
| CONTAINS (...) | Case sensitive |
| REGEXP_MATCH | Optionally Both |
Example
SELECT
segments.offer_id,
metrics.clicks
FROM MerchantPerformanceView
WHERE segments.offer_id REGEXP_MATCH "(?i)AmazingOffer\d+"
AND segments.date BETWEEN '2021-01-01' AND '2021-01-31'