Re: natural sorting

2003-10-16 Thread Roger Baklund
* 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 >

Re: natural sorting

2003-10-16 Thread 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 Chapter 2 If not, are there any plans for this feature

Re: natural sorting

2003-10-16 Thread Tobias Asplund
+ |1 | | 10 | | 11 | |2 | |3 | +--+ 5 rows in set (0.00 sec) On Thu, 16 Oct 2003, Michael Winston wrote: > Is there any way to do "natural sorting" in MySQL? That is: > Chapter 1 > Chapter 2 > Chapter 10 > > instead of > > Chapter 1 > Ch

Re: natural sorting

2003-10-16 Thread Dan Nelson
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

natural sorting

2003-10-16 Thread Michael Winston
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 helpful... Michael -- MySQL General Mailing List For list arch