Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation 'regexp_like'

select count(lug_news.n) from lug_news,lug_index where (((lug_index.all_text REGEXP '🔥')) and (t1<=1714055497 OR t1=0) AND (t2>=1714055497 OR t2=0) AND status = 'enabled' AND en_cats = '1' and lug_news.n = lug_index.n and lug_index.what = 'n')