Mysql have this option to copy one field data to another field. For this purpose run a simple query. $UserlevelMigrationQuery = “UPDATEusers SET level_id = ‘4’, preunii_email = email, migration_date = NOW(), email_verify = ‘0’ WHERE level_id = 7″; $UserlevelMigrationResult = mysql_query($UserlevelMigrationQuery, $connection) or die(mysql_error());