对某些字段转换编码:
CONVERT(表名.字段名 USING utf8) COLLATE utf8_unicode_ci;
例如:
SELECT
*
FROM uc
WHERE CONVERT(uc.phone USING utf8) COLLATE utf8_unicode_ci LIKE '云南'
对某些字段转换编码:
CONVERT(表名.字段名 USING utf8) COLLATE utf8_unicode_ci;
例如:
SELECT
*
FROM uc
WHERE CONVERT(uc.phone USING utf8) COLLATE utf8_unicode_ci LIKE '云南'