copy rows from a table and inserting into same table but changing one field

[Kevin Khan]

Any ideas how i can do this?

The structure of my database is

CREATE TABLE IF NOT EXISTS `Classified` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` varchar(255) COLLATE latin1_general_ci NOT NULL,
`description` text COLLATE latin1_general_ci NOT NULL,
`link` varchar(128) COLLATE latin1_general_ci NOT NULL,
`img1` varchar(128) COLLATE latin1_general_ci NOT NULL,
`published` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1642 ;

and all i wanna do is copy all rows that have a certain email we say [e-mail] and insert them back into the same table but changing the email to [e-mail]
kevinkhan is offline Add to kevinkhan's Reputation Report Post Edit/Delete Message