Re: Same question, better example

2006-02-20 Thread Mark Leith
leo huang wrote: Ariel, You can try this: mysql>select stri from prueba order by stri+0 desc; Leo Huang Or just make the column an INT instead of a CHAR, if you want a natural number order. Sorting is performed differently between characters and integers - as is obviously shown in the exam

Re: Same question, better example

2006-02-20 Thread leo huang
Ariel, You can try this: mysql>select stri from prueba order by stri+0 desc; Leo Huang 2006/2/17, Ariel Sánchez Mora <[EMAIL PROTECTED]>: > > mysql> describe prueba; > +---+-+--+-+-+---+ > | Field | Type| Null | Key | Default | Extra | > +---+-+