Remove duplicated entries (between 2 columns)

[Frankov Boslesky]

I have a customer table, which contains 2 email columns...

One's for the home email, the 2nd one for the office email.

I made a little php script that fetches all the emails, and sends an html email according to the table info...

Problem is, I don't want to send the email to the same address twice, and some emails avec duplicated 3 or 4 times (within diff. users)....

Here's a quick example :
http://www.question-graphique.com/problem.jpg

Is there a way to keep ONE record of each address, and update the duplicates to a blank ?

After that, I will add some code that will verify if the email is already inserted.

Thanks,