Mysql: Difference between revisions
Created page with 'category:computer * http://db4free.blogspot.com/2006/06/sorting-of-numeric-values-mixed-with.html natural sort order by cast(substr(album_name,1,2))' |
No edit summary |
||
| Line 1: | Line 1: | ||
[[category:computer]] | [[category:computer]] | ||
* http://db4free.blogspot.com/2006/06/sorting-of-numeric-values-mixed-with.html | * http://db4free.blogspot.com/2006/06/sorting-of-numeric-values-mixed-with.html | ||
*variant | |||
natural sort | natural sort | ||
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/ | |||
Revision as of 2009-09-22T12:38:12
natural sort order by cast(substr(album_name,1,2))