currently i have a table with an ip coloumn in text 123.45.67.89 though it shouldn't be a big deal to convert it to binary, but was wondering if there is an easy way to sort by closeness to a given ip address?
ie records that come out sorted as same class sub-c same class c same class c same class b same class a other addresses other addresses the only thing i can think of at this point is a really long order by <if same c>,<if same b>,<if same a> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
