MySQL Query : SELECT COUNT(*) as count FROM (SELECT m.id,m.uid,m.catid,m.title,m.url,m.thumb,m.username FROM sj_video m WHERE m.id>0 AND m.isShow=1 and (m.keywords like '%���������������������%' or m.title like '%���������������������%') and m.status=99 ORDER BY m.inputtime desc) T
MySQL Error : Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
MySQL Errno : 1267
Message : Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
Need Help?