Ilike Expression Support in Bigquery
Bigquery Throws an Error When 'Ilike' Expression Is Used. What Is the Alternative for Doing Case Insensitive Like Query? Below Is the Relevant Part of the...
BigQuery throws an error when 'ilike' expression is used. What is the alternative for doing case insensitive like query?
Below is the relevant part of the query.
SELECT id FROM `performance_last30days` WHERE device ilike 'DESKTOP'
Syntax error: Expected ")" but got "ilike"
1 Answer
SELECT id
FROM `performance_last30days`
WHERE UPPER(device) LIKE '%DESKTOP%'
or
SELECT id
FROM `performance_last30days`
WHERE REGEXP_CONTAINS(device, r'(?i)DESKTOP')
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
