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.
----- 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 :
> 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
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php