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

SELECT stp.product_id FROM search_to_product stp LEFT join search_to_search sts ON sts.search_to_search_id = stp.serach_id OR sts.search2_to_search_id2 = stp.serach_id LEFT JOIN search s ON sts.search_to_search_id = s.search_id OR sts.search2_to_search_id2 = s.search_id WHERE s.search_name REGEXP 'estanter�a' AND s.search_active = 1 group by product_id

[TEP STOP]