Answers for "case sensitive query in mysql"

mysql like case sensitive

-- Use BINARY to make LIKE sensitive
SELECT 'abc' LIKE BINARY 'ABC';		-- 0

select binary case sensitove

SELECT *  FROM `table` WHERE BINARY `column` = 'value'

none

SELECT * FROM my_table WHERE upper(MY_COLUMN) = upper('My_String');

where case insensitive mysql

SELECT * FROM `table` WHERE LOWER(`Value`) = LOWER("THE_VALUE")

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%'