It looks like your field is a text field rather than BIGINT or some
numerical field. Changing the field type should solve your problem.
Serge.
----- Original Message -----
From: "CVIOG at UGA" <cviog@stripped>
To: <mysql@stripped>
Sent: Tuesday, July 09, 2002 4:22 PM
Subject: Basic Q's: Numerical Sorting
> I have a fairly basic question: How do I sort
> numerically? Normally when I query using "ORDER BY
> (field)", it orders by the first digit (i.e. 1, 10, 2,
> 21, 3, 32) rather than by number (1, 2, 3, 10, 21,
> 32).
>
> Thanks for any help
> Dave
>
> __________________________________________________
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free
> http://sbc.yahoo.com
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread114127@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-serge=skycomp.ca@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
