1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation 'regexp_like'

Select am.article_id, article_homepage_headline, article_page_url, article_short_description, article_epoch, article_date1, article_date, article_time_r, category_id, (select cm.category_master_name from category_master cm where cm.category_master_id=am.category_id and cm.active='Y') as category_name, sub_category_id, (select scm.sub_category_master_name from sub_category_master scm where scm.sub_category_master_id=am.sub_category_id and scm.active='Y') as sub_category_name, article_image, article_image2, article_image_caption from article_master_206m am where am.article_id != 23268670 and am.category_id = 14 and am.sub_category_id = 0 and (am.article_homepage_headline RLIKE '(Big|Savings)|Click|Here|To|Buy|Tom|Selleck|CBD|Gummies|For|A|Discounted|Price|Of|Up|to|50%|Off!!|Tom|Selleck|CBD|Gummies|(Price|Drop|Alert)|Click|Here|To|Buy|Tom|Selleck|CBD|Gummies|For|As|Low|As|59.95/|Bottle:|Order|Now!!|Tom|Selleck|CBD|Gummies|(Special|Offer)|Get|Tom|Selleck|CBD|Gummies|From|The|Official|Website|For|a|Surprisingly|Low|Price|50%|Discount|Limited|Time!!|Tom|Selleck|CBD|Gummies|=>|CLICK|HERE|TO|Discount|50%|–|Tom|Selleck|CBD|Gummies|OFFICIAL|WEBSITE|Visit|the|official|website|to|order|your|supply|of|Tom|Selleck|CBD|Gummies|today!' or am.article_headline RLIKE '(Big|Savings)|Click|Here|To|Buy|Tom|Selleck|CBD|Gummies|For|A|Discounted|Price|Of|Up|to|50%|Off!!|Tom|Selleck|CBD|Gummies|(Price|Drop|Alert)|Click|Here|To|Buy|Tom|Selleck|CBD|Gummies|For|As|Low|As|59.95/|Bottle:|Order|Now!!|Tom|Selleck|CBD|Gummies|(Special|Offer)|Get|Tom|Selleck|CBD|Gummies|From|The|Official|Website|For|a|Surprisingly|Low|Price|50%|Discount|Limited|Time!!|Tom|Selleck|CBD|Gummies|=>|CLICK|HERE|TO|Discount|50%|–|Tom|Selleck|CBD|Gummies|OFFICIAL|WEBSITE|Visit|the|official|website|to|order|your|supply|of|Tom|Selleck|CBD|Gummies|today!' or am.article_tags RLIKE '(Big|Savings)|Click|Here|To|Buy|Tom|Selleck|CBD|Gummies|For|A|Discounted|Price|Of|Up|to|50%|Off!!|Tom|Selleck|CBD|Gummies|(Price|Drop|Alert)|Click|Here|To|Buy|Tom|Selleck|CBD|Gummies|For|As|Low|As|59.95/|Bottle:|Order|Now!!|Tom|Selleck|CBD|Gummies|(Special|Offer)|Get|Tom|Selleck|CBD|Gummies|From|The|Official|Website|For|a|Surprisingly|Low|Price|50%|Discount|Limited|Time!!|Tom|Selleck|CBD|Gummies|=>|CLICK|HERE|TO|Discount|50%|–|Tom|Selleck|CBD|Gummies|OFFICIAL|WEBSITE|Visit|the|official|website|to|order|your|supply|of|Tom|Selleck|CBD|Gummies|today!') order by am.article_epoch DESC LIMIT 0,5

Error