Mysql SQL Error (1267): Illegal mix of collations
Mysql SQL Error (1267): Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' If you face this error due to different collations on the tables you are joining, So you need to set collation like this in joins. Select * FROM data_temp d inner JOIN offices o ON d.School_Name COLLATE UTF8MB4_GENERAL_CI =o.name COLLATE UTF8MB4_GENERAL_CI