SELECT COUNT(*) total_count FROM news_articles WHERE uid > 0 and subject LIKE '%⁀@upinda🌅1차동의로또디비판매🅴⬄%' or writer = '⁀@upinda🌅1차동의로또디비판매🅴⬄'

Error: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'like'
File : /news/search.php