Answers for "How would you make a case-insensitive query in MySQL?"

mysql select case insensitive

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

Posted by: Guest on July-13-2021

where case insensitive mysql

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

Posted by: Guest on January-21-2021

Code answers related to "How would you make a case-insensitive query in MySQL?"