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 duplicate all rows (except auto increment id) that have a certain email we say email1@hotmail.com and insert them back into the same table but changing the email to email2@hotmail.com

that's gonna be real difficult, because your table doesn't have an email column

sorry i wasnt clear in my discription. the email field is actually the user field.

Thanks that workded perfectly