mysql is case sensitive or case insensitive code example
Example 1: where case insensitive mysql
SELECT * FROM `table` WHERE LOWER(`Value`) = LOWER("THE_VALUE")
Example 2: where case insensitive like mysql
When searching for partial strings in MySQL with LIKE you will match case-insensitive by default.
SELECT name FROM users WHERE name LIKE 't%'