Mysql: Difference between revisions
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
order by cast(substr(album_name,1,2)) | order by cast(substr(album_name,1,2)) | ||
* the +0 way http://blog.feedmarker.com/2006/02/01/how-to-do-natural-alpha-numeric-sort-in-mysql/ | * the +0 way http://blog.feedmarker.com/2006/02/01/how-to-do-natural-alpha-numeric-sort-in-mysql/ | ||
** doesnt work | |||
Revision as of 2009-09-22T12:56:45
natural sort order by cast(substr(album_name,1,2))
- the +0 way http://blog.feedmarker.com/2006/02/01/how-to-do-natural-alpha-numeric-sort-in-mysql/
- doesnt work