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
