Well, you can do something like:
SELECT * FROM tablename ORDER BY fieldname [ASC|DESC] => [ASC|DESC] optional, put either of theses without the brackets. //Elias. "Joel Colombo" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > This is a mysql question, cause i can do it with a natsort in php. > question is can u do it directly in the MYSQL SELECT ? > I am wondering if the SELECT statement can have a natural order by. > > Table has 5 rows. > field name "number" > values : > 10 > 2 > 15 > 30 > 150 > > a regular order by "number": generates results 10,15,150,2,30 > > i need a natural sort.... > 2,10,15,30,150 > > is there a way to sort FLOAT valuse like this using an order by with a combo > of other functions or something ? > > Thanks > Joel > > > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php