RsD0p9BK
5/4/2016 - 10:24 AM

from: http://stackoverflow.com/questions/153633/natural-sort-in-mysql

from: http://stackoverflow.com/questions/153633/natural-sort-in-mysql

sort__natural.sql
content_copyfile_download
-- Natural Sort in MySQL

SELECT names FROM your_table ORDER BY games + 0 ASC;

SELECT alphanumeric, integer
FROM sorting_test
ORDER BY LENGTH(alphanumeric), alphanumeric;

-- http://www.copterlabs.com/natural-sorting-in-mysql/