Mysql: Difference between revisions
No edit summary |
No edit summary |
||
| Line 10: | Line 10: | ||
http://stackoverflow.com/questions/23921117/disable-only-full-group-by | http://stackoverflow.com/questions/23921117/disable-only-full-group-by | ||
* rewrite query with ANY_VALUE(column) | * 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" | |||
Revision as of 2017-01-10T04:07:47
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"