COLLATE 转换指定字符集
utf8 格式
SELECT column_name
FROM table_name
WHERE column_name COLLATE utf8_bin LIKE 'value'
utf8mb4 字符集的
SELECT column_name
FROM table_name
WHERE column_name COLLATE utf8mb4_bin LIKE 'value'
根据实际需求选择适合的字符集
aki
keyboard warrior
COLLATE 转换指定字符集
utf8 格式
SELECT column_name
FROM table_name
WHERE column_name COLLATE utf8_bin LIKE 'value'
utf8mb4 字符集的
SELECT column_name
FROM table_name
WHERE column_name COLLATE utf8mb4_bin LIKE 'value'
根据实际需求选择适合的字符集