MySQL - Finding duplicates

[Anon]

I have a DBase of customer information for the ISP I work for. I am trying to find an SQL query that will show the duplicates from the IP Address field in that database.
The following code:
SELECT NAME, IPADDR FROM tablename
GROUP BY IPADDR
HAVING COUNT(*) > 1;
will give me the duplicate IP addresses, but it will only give me information (i.e. Name, etc.) for ONE of the duplicates, not BOTH. Is there a similar query that will show only duplicates, but will show the field information for both duplicates...not just one?
Any help would be super.
Justin

[Anon]

This should work.

SELECT FROM tablename WHERE IPADDR IN
(SELECT IPADDR FROM tablename
GROUP BY IPADDR
HAVING COUNT() > 1)

You can add ORDER BY IPADDR to the end to print it out in a nice order. You can also replace the first * with name, ipaddr or just the fields you want for readablity.

[Anon]

It should work, only MySQL doesn't support sub-selects :-(