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?
