Posted by Zoe Brown on 09/08/05 22:18

"yellow1912" <yellow1912@yahoo.com> wrote in message
news:1126205568.698426.143650@z14g2000cwz.googlegroups.com...
> Thanks a bunch!!!
>
> But I ran into this:
> For example I have a column "NAME" contains name:
> Name 1
> Name 2
> ....
> Name 99
>
> If I ORDER BY NAME DESC I will get something like this:
> Name 99
> Name 98
> .....
> Name 90
> Name 8 //The problems is here
> Name 89
> Name 88
> .....
>
> The problem, I believe, is because of the way mysql compares the
> strings. Hence make this sort kinda weird! How can I fix this, any
> walk-around?

make sure your feild type is set to integer ?

[Back to original message]