Mysql

---

• http://db4free.blogspot.com/2006/06/sorting-of-numeric-values-mixed-with.html
• variant

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)

http://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html "In MySQL 5.7.5 and higher, ONLY_FULL_GROUP_BY also affects handling of queries that use DISTINCT and ORDER BY"