#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);