Apologies for the previous duplicate post.
--- On Fri, 25/9/09, Tony <td_mi...@yahoo.com> wrote:
> I'm creating a spreadsheet with the info from
> mySQL for pmacct and then manually copying stuff from the
Quick question (that is way off topic). The IP address field is stored in mySQL
as a CHAR. Is there an easy way to sort by IP address ?
If I try to "order by" in SQL then I get:
x.y.18.0
x.y.18.1
x.y.18.10
x.y..18.100
x.y.18.101
...
x.y.18.99
for a single /24. This is because it's a CHAR value and so it's ordered
"alphabetically".
Is there a way to sort it properly by IP address (so that .2 comes after .1) in
either an SQL query or in an XLS sheet ?
Thanks,
Tony.
__________________________________________________________________________________
Get more done like never before with Yahoo!7 Mail.
Learn more: http://au.overview.mail.yahoo.com/
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
