Help With MySQL Query
Hey guys, this must be a weird question but...I'm trying to find duplicates of IP addresses having the same first two/three octects.
I know how to find duplicates for an IP address...here's how.
SELECT player_ip, COUNT(player_ip) AS NumOccurrences FROM amx_bans GROUP BY player_ip HAVING ( COUNT(player_ip) > 1 )
However, in that database no two player_ip are the same (obviously).
So what I need to find is the first two octets. XXX.XXX.BLAH.BLAH that are the same. Is that possible?