#1  
Old 25th September 2009, 01:45
P4rD0nM3 P4rD0nM3 is offline
Junior Member
 
Join Date: May 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default 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?
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix: "unknown user" with mysql auth. Kruser Server Operation 3 18th June 2009 18:20
ISPconfig 3, dropmail issue Justin Albstmeijer Developers' Forum 10 6th October 2008 21:21
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Rejected e-mail (unknown user) w/Postfix doronkeller HOWTO-Related Questions 9 27th January 2008 20:09
Multiple MySQL Queries - with Postfix-mysql, courier-authmysql, maildrop-mysql... snowfly HOWTO-Related Questions 4 7th July 2006 04:19


All times are GMT +2. The time now is 20:42.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.