Re: order by problem

On Wed, 20 Mar 2002 guslist@kerntec.net wrote: You have your ctrlnumber field defined as varchar. If you define ctrlnumber as number, you could also use SELECT max(ctrlnumber) FROM table WHERE id=14; Cheers Urosh > Hello All, > > I´m having a 'problem' that I dont know how to resolve. The problem is: > > I have a table that I want to get the last number to increment. To do this I > want to sort the filed 'ctrlnumber'. Using this query´s I get: > mysql> SELECT ctrlnumber FROM table WHERE id=14; > +------------+ > | ctrlnumber | > +------------+ > | 7 | > | 1 | > | 2 | > | 3 | > | 4 | > | 5 | > | 6 | > | 8 | > | 9 | > | 10 | > | 11 | > +------------+ > 11 rows in set (0.00 sec) > > mysql> SELECT ctrlnumber FROM table WHERE id=14 order by ctrlnumber; > +------------+ > | ctrlnumber | > +------------+ > | 1 | > | 10 | > | 11 | > | 2 | > | 3 | > | 4 | > | 5 | > | 6 | > | 7 | > | 8 | > | 9 | > +------------+ > 11 rows in set (0.01 sec) > > > When I try to sort, it doesn´t return to me in the order that I need (1 2 3 > 4 5 6 7 8 9 10 11). Is there a way to do this or I´ll have to include 01 02 > 03 04 05.... to all my recoreds ? > > Thank´s in advance, > Gus > > >