Re: Sorting Fields with varchar and Int

Ah - now I understand your dilemma. Creative try at solving the solution. I can think of two quick (and not super accurate) fixes. 1.) select field+0 as num, substr(field,length(num)) as str ... order by num, str 2.) select ... order by field+0, soundex(field) Good Luck! --zak ----- Original Message ----- From: "PHPWIN" <phpwin@hotmail.com> To: <php-windows@lists.php.net> Sent: Wednesday, October 11, 2000 11:09 AM Subject: Re: [PHP-WIN] Sorting Fields with varchar and Int > actually i sorted by using this: > $sql="select * from table where field like '%".$this."%' > order by field+0,field+'' "; > works by sorting the field which is a varchar() by number then as a string > again > however cant seem to get round the string bit > coz I want to sort by the number 1,2,3.... first then followed by a,b,c... > Thanx > Xon > > ----- Original Message ----- > From: "Zak Greant" <zak@php.net> > To: "PHPWIN" <phpwin@hotmail.com> > Cc: <php-windows@lists.php.net> > Sent: Thursday, October 12, 2000 2:27 AM > Subject: Re: [PHP-WIN] Sorting Fields with varchar and Int > > > > order by field_name > > > > --zak > > > > At 07:23 PM 10/11/00 +0800, PHPWIN wrote: > > >Hi > > > Does anyone know how to sort these columns in MySql from > > >+------+ > > > I 1b I > > >+------+ > > > I 1c I > > >+------+ > > > I 2b I > > >+------+ > > > I 1a I > > >+------+ > > > I 2a I > > >+------+ > > > > > >to this > > >+------+ > > > I 1a I > > >+------+ > > > I 1b I > > >+------+ > > > I 1c I > > >+------+ > > > I 2b I > > >+------+ > > > I 2a I > > >+------+ > > > > > >if the fields are varchar() > > > > > >cheers > > >Xon > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >