Wildcard Search in MySQL, LIKE '%string%' (Fiddle)

Question

I want to search data with condition name = '%Park%'

this is my sample code in Fiddle. http://sqlfiddle.com/#!9/d0e059/12

when I tried in BigQuery, It returns case sensitive result. data exactly match with 'Park'. not 'PARK','park'

But in mySQL test which I linked, it returns all alphabetic 'Park' contains 'PARK','park' (no case sensitive)

Does mySQL originally NO CASE SENSITIVE EVEN IN DATA? Or did I go wrong in something??

Answer 1

For case in MySQL you can use LIKE BINARY;

SELECT name, host_name, borough, district, price
FROM airbnb
WHERE name LIKE BINARY '%park%';

MySQL like binary