Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation 'like'
select * from ***_ecms_shop where classid in (103,104) and pxfl like '%银行从业%' order by id desc limit 10