how to check case sensitive in mysql query code example

Example: oracle sql select case insensitive

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