How can I delete redundant duplicates in MySQL?
| From: | Trond Erling Hundal | 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...