mysql case sensitive code example
Example 1: select binary case sensitove
SELECT * FROM `table` WHERE BINARY `column` = 'value'
Example 2: oracle sql select case insensitive
SELECT * FROM my_table WHERE upper(MY_COLUMN) = upper('my_string');
SELECT * FROM `table` WHERE BINARY `column` = 'value'
SELECT * FROM my_table WHERE upper(MY_COLUMN) = upper('my_string');