query:SELECT COUNT(*) as num FROM job_hire INNER JOIN job_member on h_comid=m_id WHERE m_flag=1 and DATEDIFF(m_startdate,'2021-05-17')<=0 and DATEDIFF(m_enddate,'2021-05-17')>=0 and h_status=1 and (h_comname like '%饲养员%' or h_place like '%饲养员%' or h_introduce like '%饲养员%')|errno:1267|error:Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'|errmsg:MySQL Query Error