Well, you can do something like:
SELECT * FROM tablename
ORDER BY fieldname [ASC|DESC]
=> [ASC|DESC] optional, put either of theses without the brackets.
"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 :
> a regular order by "number": generates results 10,15,150,2,30
> i need a natural sort....
> is there a way to sort FLOAT valuse like this using an order by with a
> of other functions or something ?
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php