List:General Discussion« Previous MessageNext Message »
From:Serge Paquin Date:July 9 2002 8:30pm
Subject:Re: Basic Q's: Numerical Sorting
View as plain text  
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
>

Thread
Basic Q's: Numerical SortingCVIOG at UGA9 Jul
  • Re: Basic Q's: Numerical SortingSerge Paquin9 Jul
  • Re: Basic Q's: Numerical SortingDan Nelson9 Jul
RE: Basic Q's: Numerical SortingLuc Foisy9 Jul