I have a MySQL table where I store all user logins. I also keep IP addresses from users.
Structure of my table
Now If I doubt that two users are multi-account I want to compare all IP addresses from both users and see how many IP addresses are used by both users.
With this query, I will get all IP addresses used by both users.
SELECT IP,count(IP) from MultiAcc WHERE dbID = '2' OR dbID= '3' GROUP BY IP ORDER BY count(IP)
For example for these users I get a total of 106 different IP addresses, Now I want to check how many of them are used by both users. Is this possible?