| Ariel Sánchez Mora 2006-02-25, 9:43 am |
| 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=3D'10.100.1.1'; and have never had any problems. However, if you plan =
on sorting based on this column, strings with periods do not behave =
correctly, and the answers to my previous question on this list do not =
apply; it makes a good aproximation, though.
Hope this helps, but I must admit I am not sure if this answers your =
question. An example in the mysql console would be great for clearing up =
your objetive.
Regards,
Ariel
-----Mensaje original-----
De: CodeHeads [mailto:ch@code-heads.com]=20
Enviado el: mi=E9rcoles, 22 de febrero de 2006 15:53
Para: MySQL-List
Asunto: 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 =
field (IP Address). Can MySQL search for numbers??
Thanks,
Will
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/mysql? unsub...bp
.fi.cr
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|