Answers for "case sensitive mysql"

mysql like case sensitive

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

Posted by: Guest on June-19-2021

select binary case sensitove

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

Posted by: Guest on June-23-2020

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

Posted by: Guest on January-31-2021

Code answers related to "case sensitive mysql"