I know that MySQL will do a natural sort on INT fields becuase I often use an integer for my index. But I don't know about a FLOAT field. Seems like it should doesn't it? Sorry I don't have a direct answer for you. You might want to check www.mysql.com if you haven't already. -Kevin
----- Original Message ----- From: "Joel Colombo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 29, 2002 1:27 PM Subject: [PHP] MYSQL natsort() ? > 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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
