Simple SELECT statment

[luiddog]

I've been trying to figure out this select statment.

I have a db called 'login' which stores users' names and IPs. I'm trying to see users that login from multiple IPs

SELECT * FROM login GROUP BY IP HAVING (user > 2)

I know that's wrong but what do I do?

[devinemke]

SELECT COUNT(*) AS repetitions, ip, user FROM logins GROUP BY ip, user HAVING repetitions > 1