RE: Number Searches

2006-02-24 Thread John Trammell
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

RE: Number Searches

2006-02-24 Thread CodeHeads
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 application uses IP

RE: Number Searches

2006-02-23 Thread Ariel Sánchez Mora
@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 great since my application uses IP addresses as strings in all cases

RE: Number Searches

2006-02-23 Thread CodeHeads
: CodeHeads [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 22 de febrero de 2006 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

Re: Number Searches

2006-02-23 Thread Mathieu Bruneau
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

Re: Number Searches

2006-02-23 Thread CodeHeads
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

Re: Number Searches

2006-02-22 Thread Rhino
- Original Message - From: CodeHeads [EMAIL PROTECTED] To: MySQL-List mysql@lists.mysql.com 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

Re: Number Searches

2006-02-22 Thread David T. Ashley
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

RE: Number Searches

2006-02-22 Thread Ariel Sánchez Mora
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

RE: Number Searches

2006-02-22 Thread CodeHeads
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 column