Google BigQuery case insensitive match

Question

How would I run the following query, like I would again mysql:

SELECT * FROM [integrated-myth-15.testing_data_100k]
WHERE title='down in la'

Now it will match if I have a perfect case-sensitive string match, but how would I do it case insensitive for "down in la"? I'm working from the Web console.

Answer 1

The standard way to do this is using LOWER or UPPER on the input string, e.g.:

#legacySQL
SELECT * FROM [integrated-myth-15.testing_data_100k]
WHERE LOWER(title) = 'down in la';

Or:

#standardSQL
SELECT * FROM `integrated-myth-15.testing_data_100k`
WHERE LOWER(title) = 'down in la';