Answers for "select with 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

mysql select case insensitive

SELECT id 
  FROM groups
 WHERE LOWER(name)=LOWER('Administrator')

Posted by: Guest on July-13-2021

Code answers related to "select with case sensitive mysql"