mysql when like case sensitive code example

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