On Fri, 2006-02-24 at 10:02 -0600, John Trammell wrote:
> > On Wed, 2006-02-22 at 16:49 -0600, Ariel Sánchez Mora wrote:
> > > So far i've been able to store ip addresses as strings like
> > you would
> > > type them in DOS, for ex, '192.168.0.1'. This serves me
> > great since my
> > > applicati
> On Wed, 2006-02-22 at 16:49 -0600, Ariel Sánchez Mora wrote:
> > So far i've been able to store ip addresses as strings like
> you would
> > type them in DOS, for ex, '192.168.0.1'. This serves me
> great since my
> > application uses IP addresses as strings in all cases. I've done
> > queries
On Thu, 2006-02-23 at 22:04 -0500, Mathieu Bruneau wrote:
> Ok I got 2 informations for you:
>
> 1) IPv4 address are actually 32 bit integer, easily store in 32 bits
> fast search etc etc etc (You can google for more on this storage
> format). Normally you could find a way to goes from the string
CodeHeads a écrit :
> On Wed, 2006-02-22 at 16:49 -0600, Ariel Sánchez Mora wrote:
>> So far i've been able to store ip addresses as strings like you would
>> type them in DOS, for ex, '192.168.0.1'. This serves me great since my
>> application uses IP addresses as strings in all cases. I've done
>
-+--+--+-+
> | 1 | 192.168.1.0 | x | x| x | x | x
> | x| x
> | x| x | x | x| x| x | 0 | x | x
> |
> +-+-+-+--+---+---+--+--+--+--+---------+----
> 1 row in set (0.00 sec)
>
> -Men
006 17:35
Para: Ariel Sánchez Mora
CC: mysql@lists.mysql.com
Asunto: RE: Number Searches
On Wed, 2006-02-22 at 16:49 -0600, Ariel Sánchez Mora wrote:
> So far i've been able to store ip addresses as strings like you would
> type them in DOS, for ex, '192.168.0.1'. This serves me
On Wed, 2006-02-22 at 16:49 -0600, Ariel Sánchez Mora wrote:
> So far i've been able to store ip addresses as strings like you would
> type them in DOS, for ex, '192.168.0.1'. This serves me great since my
> application uses IP addresses as strings in all cases. I've done
> queries with the IP colu
So far i've been able to store ip addresses as strings like you would type them
in DOS, for ex, '192.168.0.1'. This serves me great since my application uses
IP addresses as strings in all cases. I've done queries with the IP column ,
for example, select office_name from table_1 where ip='10.100
On Wed, February 22, 2006 4:52 pm, CodeHeads wrote:
>
> I have a full index index on a table and on of the fields is a number
> field (IP Address). Can MySQL search for numbers??
>
I'm potentially introducing confusion here, because I've never actually
_used_ MySQL, but can't you do one of the fol
- Original Message -
From: "CodeHeads" <[EMAIL PROTECTED]>
To: "MySQL-List"
Sent: Wednesday, February 22, 2006 4:52 PM
Subject: Number Searches
Hello all,
I have searched but cannot find what I am looking for.
I have a full index index on a table and on of the fields is a number
fiel
10 matches
Mail list logo
