I have a MySQL table that has 2 columns (ip\_address and customer\_id). I am trying to find a way within MySQL to find people who have logged in with multiple accounts but the same IP.

For example if customer\_id 3 and customer\_id 7 have both logged in on 1.1.1.1 I want to be able to find this.

I don't need to know if it is the same user on the same IP (or the same user on different IPs), just if it is different users on the same IP.