I have a registration database with name, email, address, etc.

The problem is that I have some entries with the same email address. What I want to do run an SQL statement which finds duplcates in the database, keep one, and remove the duplicates.

Does such a command exist in SQL?

I'm running:
- Win XP Pro IIS
- ASP
- MySQL 4

Thanks in advanced.

what about something like
<pre id=code><font face=courier size=2 id=code>
DELETE FROM table WHERE COUNT(e-mail) &gt; 1 GROUP BY email
</font id=code></pre id=code>
not sure if it works. just an idea

------------------------
Julio

PHP | MySQL | DWMX

ICQ: 19735247
MSN:

You could also use SELECT and copy the good records to a temp table, delete the old table and then rename the temp table.

Stephen Cox
web.net geek