Re: How can I delete redundant duplicates in MySQL?

At 17:45 6-10-00 +0200, Trond Erling Hundal wrote:

Hey there good ppl... I need to delete redundant duplicates of an email field in my DB. I can`t make the email field "unique" because I actually need to be able to insert duplicates. Because my boss is the one making lists over emails, and sometimes there are severeal copies of the same email address within his lists. I load long files with adresses into MYSQL. I need to filter out the redundant duplicates of emails... Can someone help me??? I am desperate...

Make the email field unique in mysql and insert the records (emails?) into the datbase with the option IGNORE This will let you insert all unique email-adresses without mysql complaining about duplicates (it will ignore them and doesn't insert the WHOLE record into the db) Greetz, Wico

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net