Answers for "mysql case sensitive like"

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

Posted by: Guest on January-31-2021

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 "mysql case sensitive like"