UPDATE `table` tbl_1 INNER JOIN `table` tbl_2 ON tbl_2.id = tbl_1.id SET tbl_1.field1 = tbl_2.field1;
Pingback: 3landing