Mysql: Difference between revisions
No edit summary |
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 | *variant | ||
| Line 6: | Line 7: | ||
* 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 | ** doesnt work | ||
----------------- | |||
http://stackoverflow.com/questions/23921117/disable-only-full-group-by | |||
* rewrite query with ANY_VALUE(column) | |||
Revision as of 2017-01-10T03:58:03
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
http://stackoverflow.com/questions/23921117/disable-only-full-group-by
- rewrite query with ANY_VALUE(column)