mysql case sensitive like code example

Example 1: oracle sql select case insensitive

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

Example 2: 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%'