Yes, sorry. I have a database that records ip of attacks on a customer server, what I like to do get a count so that I can see what subnet is doing the major of the attacks.
select ip from ipslimit 10; +-----------------+-----------+ | ip | count(ip) | +-----------------+-----------+ | 83.117.196.206 | 1 | | 85.17.109.28 | 1 | | 125.138.96.19 | 1 | | 89.110.148.253 | 1 | | 192.168.105.10 | 1 | | 200.170.124.72 | 1 | | 201.116.98.214 | 1 | | 202.168.255.226 | 1 | | 203.89.243.158 | 1 | | 210.245.207.217 | 1 | +-----------------+-----------+ 10 rows in set (0.00 sec) > On Wed, Jul 23, 2008 at 11:45 AM, <[EMAIL PROTECTED]> wrote: >> Guys, >> >> I have been fighting with mysql trying to get it to only show every >> after >> the last dot(.) on a ip. for example >> >> instead geting 10.0.0.0 only get 10.0.0 > > As pulled from a database row? Sorry, I didn't quite understand your > email. > > -- > </Daniel P. Brown> > Better prices on dedicated servers: > Intel 2.4GHz/60GB/512MB/2TB $49.99/mo. > Intel 3.06GHz/80GB/1GB/2TB $59.99/mo. > Dedicated servers, VPS, and hosting from $2.50/mo. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]