Mysql: Difference between revisions
No edit summary |
No edit summary |
||
| Line 7: | 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 | ||
- | ==MySQL 5.7.5 - ONLY_FULL_GROUP_BY== | ||
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) | ||
Revision as of 2017-01-10T04:11:06
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
MySQL 5.7.5 - ONLY_FULL_GROUP_BY
http://stackoverflow.com/questions/23921117/disable-only-full-group-by
- rewrite query with ANY_VALUE(column)
- disable: SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',));
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"