paynemagi.magidesign.com
Date: Wed Jul 23 2008 - 11:10:14 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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, <paynemagi.magidesign.com> 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]