Answers for "mysql case sensitive search"

SQL
1

mysql like case sensitive

-- Use BINARY to make LIKE sensitive
SELECT 'abc' LIKE BINARY 'ABC';		-- 0
Posted by: Guest on June-19-2021
0

select binary case sensitove

SELECT *  FROM `table` WHERE BINARY `column` = 'value'
Posted by: Guest on June-23-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language