#1267 - Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='
CBEShop - cross border E-commerce shop,multiple merchant multi store online shopping system( https://www.crossborderpower.com)
#1267 - Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='
set $valuex='+1 213 425 1453';
update `mt_user` u set status='disabled' where u.id in (SELECT uo.user_id FROM `mt_user_overview` uo where uo.contact_phone = $valuex);
Comment
Login To Comment
No Comments