title: How to implement "LIKE ANY" in BigQuery (standard SQL)?
body: <p>I would like to use "like any" function. However, BigQuery doesnot recognize "ANY" operator. Is there any function which can replace "LIKE ANY" ?</p>
  
  <p>Bigquery - Standard SQL</p>
  
  <pre><code>    SELECT
        date,
        CONCAT(fullvisitorid, CAST(visitid AS string)) ord_browsers,
        hits.appInfo.landingScreenName,
        channelgrouping,
        trafficSource.source,
        trafficSource.medium,
        CASE
          WHEN channelgrouping = 'seo_brand' THEN 'Branded'
          WHEN hits.appInfo.landingScreenName LIKE '%/article%'
        OR hits.appInfo.landingScreenName LIKE '%/p/%' THEN 'ADS'
          WHEN (hits.appInfo.landingScreenName LIKE ANY ('%/damesmode/%',  '%/herenkleding/%',  '%/kinderkleding/%',  '%/sportkleding/%')) THEN 'Plist'
          ELSE 'rest'
        END Landing_page
      FROM
        `meta-geography-145406.81187684.ga_sessions_*`,
        UNNEST(hits) AS hits
      WHERE
        (_table_suffix BETWEEN '20190201'
          AND '20190207')
  </code></pre>
  
  <p>Syntax error: Unexpected keyword ANY at [12:47]</p>