Query to SELECT.

If `ip` occurs more than once in table

[ceil]

How can I SELECT all the rows that occur when `ip` occurs more than once in that table?

[aspdaddy]

I dont have a database to test but I think its something like this:

SELECT IP, count(IP)
FROM table
WHERE count(IP) >1
GROUP BY IP

OR
SELECT IP, count(IP)
FROM table
GROUP BY IP
HAVING count(IP) >1

[ceil]

SELECT IP, count(IP)
FROM table
GROUP BY IP
HAVING count(IP) >1

Worked

[ceil]

Thanks