RE: [PHP-DB] How can I delete redundant duplicates in MySQL?

Sounds to much like some sort of spam site ! -----Original Message----- From: Trond Erling Hundal [mailto:webmaster@port-industry.com] Sent: vrijdag 6 oktober 2000 17:46 To: php-db@lists.php.net Subject: [PHP-DB] How can I delete redundant duplicates in MySQL? 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... -- 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