mysql ignore case code example
Example 1: where case insensitive mysql
SELECT * FROM `table` WHERE LOWER(`Value`) = LOWER("THE_VALUE")Example 2: select binary case sensitove
SELECT * FROM `table` WHERE BINARY `column` = 'value'SELECT * FROM `table` WHERE LOWER(`Value`) = LOWER("THE_VALUE")SELECT * FROM `table` WHERE BINARY `column` = 'value'