note 64851 rejected from function.natsort by nlopess
| From: | nlopess@php.net | Date: | Fri, 21 Apr 2006 22:28:18 +0000 |
| Subject: | note 64851 rejected from function.natsort by nlopess | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-108965@lists.php.net to get a copy of this message | ||
Note Submitter: dezine at mixmail dot com
----
Hi, I was read the last note, with "order by does not suport natural sort" subject.
There is my problem: I have a little query, it returns a number list, but it's unordered:
1, 10, 11..., 2, 20...
How can I do the natural order in a query?? Results like this:
1, 2, 3... 10, 11..., 20...
SELECT * FROM table ORDER BY number
Thanks!!
Please, if you can help me, notify to my email. ;D