Mysql 查询临时改变某个字段字符编码

select a*
from table a
inner join table b on a.field1 collate utf8mb4_unicode_ci  = b.field2