Answers for "case insensitive query in mysql"

2

mysql select case insensitive

SELECT id 
  FROM groups
 WHERE LOWER(name)=LOWER('Administrator')
Posted by: Guest on July-13-2021
1

where case insensitive mysql

SELECT * FROM `table` WHERE LOWER(`Value`) = LOWER("THE_VALUE")
Posted by: Guest on January-21-2021
0

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%'
Posted by: Guest on January-21-2021

Code answers related to "case insensitive query in mysql"

Browse Popular Code Answers by Language