Mysql: Difference between revisions
No edit summary |
|||
| Line 1: | Line 1: | ||
[[ | [[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 | *variant | ||
Revision as of 2013-06-09T22:22:51
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