Als je dit hebt:
mysql> SELECT version
-> FROM version_sorting
-> ORDER BY version;
+---------+
| version |
+---------+
| 1 |
| 10 |
| 11 |
| 12 |
| 2a |
| 4b |
| 5a |
| 5b |
+---------+
8 rows in set (0.03 sec)
Dan kun je sorteren met:
mysql> SELECT version
-> FROM version_sorting
-> ORDER BY CAST(version AS UNSIGNED), version;
+---------+
| version |
+---------+
| 1 |
| 2a |
| 4b |
| 5a |
| 5b |
| 10 |
| 11 |
| 12 |
+---------+
This entry was posted
on Thursday, June 29th, 2006 at 8:47 am and is filed under Mysql.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.