UPDATE `table` tbl_1
INNER JOIN `table` tbl_2 ON tbl_2.id = tbl_1.id
SET tbl_1.field1 = tbl_2.field1;