MySQL ERROR:

Error Number: 1267

Description: Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

Query: SELECT p.page_name, n.namespace_label FROM exp_wiki_page AS p LEFT JOIN exp_wiki_namespaces AS n ON n.namespace_name = p.page_namespace LEFT JOIN exp_wiki_revisions AS r ON r.revision_id = p.last_revision_id WHERE r.page_content REGEXP '\\[\\[index[[:>:]].*\\]\\]' AND p.wiki_id = '1'