Case-sensitive fields in MySQL
By default, MySQL treats all fields as case-insensitive. Here is how to change this behavior for some fields in a table or for a specific SELECT query:
for table fields:
If you set the field collation as utf8_binary instead of utf8_general_ci (or similar), that field will be case sensitive.
for select queries:SELECT * FROM table_name WHERE BINARY field LIKE '%keyword%'
Add new comment