[joeakablue]

Searching for duplicate IP addresses in a database, what's the best way to handle this? I've pulled most of my hair out trying to dig through the mysql and php resources online in an effort to return this information:

selecting non unique IP addresses from a mysql table. Sort of reverse the results you'd get from

SELECT DISTINCT ip_address FROM table_name

This has got to be an easily done thing. Any help anyone can offer? I'm new to this kind of thing, but have learned a lot int he last year of OS X and web development.

thanks in advance!
joe

[pumpkinapo]

I've done something similar with MSSQL 2000, but the SQL code should be similar. Try this, it'll list all the ipaddress but the duplicates will be at the top of the list.

SELECT ip_address, count(ip_address) FROM table_name GROUP BY ip_address ORDER BY count(ip_address) desc

You should get a listing similar to this:
10.1.1.1 2
10.1.1.2 2
10.1.1.3 1

First column is the ip address, second column is the number of times it appears.

Hope this helps.