How can I delete redundant duplicates in MySQL?

From: Date: Fri, 06 Oct 2000 15:45:45 +0000
Subject: How can I delete redundant duplicates in MySQL?
Groups: php.db 
Request: Send a blank email to php-db+get-3382@lists.php.net to get a copy of this message
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...

« previous php.db (#3382) next »