Answers for "set case sensitive mysql"

SQL
2

none

SELECT * FROM my_table WHERE upper(MY_COLUMN) = upper('My_String');
Posted by: Guest on January-31-2021
1

where case insensitive mysql

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

Code answers related to "SQL"

Browse Popular Code Answers by Language