-REPLACE IGNORE INTO profile_display (pid, promo)
- SELECT uid, CONCAT("X", entry_year)
- FROM profile_education
- WHERE FIND_IN_SET('primary', flags);
+ UPDATE profile_display AS d
+INNER JOIN profile_education AS e ON (d.pid = e.pid)
+ SET d.promo = CONCAT("X", entry_year)
+ WHERE FIND_IN_SET('primary', e.flags);