Convert specified character set
utf8 format
SELECT column_name
FROM table_name
WHERE column_name COLLATE utf8_bin LIKE 'value'
utf8mb4 character set
SELECT column_name
FROM table_name
WHERE column_name COLLATE utf8mb4_bin LIKE 'value'
Choose the appropriate character set according to actual needs