* Michael Winston
> At 2:06 PM -0500 10/16/2003, Dan Nelson wrote:
> >In the last episode (Oct 16), Michael Winston said:
> >> Is there any way to do "natural sorting" in MySQL? That is:
> >> Chapter 1
> >> Chapter 2
> >> Chapter 10
> >>
> >> instead of
> >>
> >> Chapter 1
> >> Chapter 10
>
At 2:06 PM -0500 10/16/2003, Dan Nelson wrote:
In the last episode (Oct 16), Michael Winston said:
Is there any way to do "natural sorting" in MySQL? That is:
Chapter 1
Chapter 2
Chapter 10
instead of
Chapter 1
Chapter 10
Chapter 2
If not, are there any plans for this feature in future r
If you have 4.0.2 or later you can use the CAST() function, if you have
earlier you should be able to emulate it with the BINARY keyword for the
ORDER BY clause, examples below:
[EMAIL PROTECTED]:tmp > CREATE table sort (
-> num int
-> );
Query OK, 0 rows affected (0.00 sec)
[EMAIL PRO
In the last episode (Oct 16), Michael Winston said:
> Is there any way to do "natural sorting" in MySQL? That is:
> Chapter 1
> Chapter 2
> Chapter 10
>
> instead of
>
> Chapter 1
> Chapter 10
> Chapter 2
>
> If not, are there any plans for this feature in future releases?
> Would be pretty he
