Natural Sort in MySQL

by

Here is a quick solution:

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

More Related Contents:

  1. Humanized or natural number sorting of mixed word-and-number strings
  2. Alphanumeric sorting with PostgreSQL
  3. MySQL LIKE IN()?
  4. In MySQL queries, why use join instead of where?
  5. Why would an IN condition be slower than “=” in sql?
  6. PostgreSQL GROUP BY different from MySQL?
  7. GROUP BY behavior when no aggregate functions are present in the SELECT clause
  8. MySQL dump by query
  9. SQLite – ORDER BY RAND()
  10. Delete sql rows where IDs do not have a match from another table
  11. How to search multiple columns in MySQL?
  12. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  13. How to use SQL Order By statement to sort results case insensitive?
  14. What does DELIMITER // do in a Trigger?
  15. Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
  16. MySQL equivalent of DECODE function in Oracle
  17. How do you version your database schema? [closed]
  18. PostgreSQL ORDER BY issue – natural sort
  19. MySQL, Get users rank
  20. Mysql: how to select groups having certain values?
  21. How to fill date gaps in MySQL?
  22. Adding a new SQL column with a default value
  23. Boolean vs tinyint(1) for boolean values in MySQL
  24. MySQL full text search for words with three or less letters
  25. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  26. Function for week of the month in mysql
  27. MySQL’s alternative to T-SQL’s WITH TIES
  28. Find rows that have the same value on a column in MySQL
  29. what is the difference between GROUP BY and ORDER BY in sql
  30. How do MySQL views work?

Leave a Comment