In MySQL, the LIKE operator is case-insensitive by default when used with string columns that have a collation that is case-insensitive (such as utf8_general_ci). However, if the column uses a case-sensitive collation (like utf8_bin), then the LIKE operator will be case-sensitive.
You can check the collation of your column to determine the behavior of the LIKE operator. If you want to perform a case-sensitive search regardless of the column's collation, you can use the BINARY keyword:
SELECT * FROM your_table WHERE BINARY your_column LIKE 'your_pattern';
