Case sensitivity

Stay organized with collections Save and categorize content based on your preferences.

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'