mysql sort string number

by

Quickest, simplest? use * 1

select *
from tbl
order by number_as_char * 1

The other reasons for using * 1 are that it can

  1. survive some horrendous mishaps with underflow (reduced decimal precision when choosing what to cast to)
  2. works (and ignores) columns of purely non-numeric data
  3. strips numeric portions of alphanumeric data, such as 123A, 124A, 125A

More Related Contents:

  1. 1052: Column ‘id’ in field list is ambiguous
  2. Codeigniter – multiple database connections
  3. How to add levenshtein function in mysql?
  4. #1071 – Specified key was too long; max key length is 1000 bytes
  5. Is the primary key automatically indexed in MySQL?
  6. Is there ANY_VALUE capability for mysql 5.6?
  7. Cumulative sum over a set of rows in mysql
  8. MySql Error 150 – Foreign keys
  9. No connection could be made because the target machine actively refused it (PHP / WAMP)
  10. Add Auto-Increment ID to existing table?
  11. MySQL SELECT DISTINCT multiple columns
  12. How to connect to a MySQL Data Source in Visual Studio
  13. DOs and DONTs for Indexes [closed]
  14. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  15. How do I get the first day of the week of a date in mysql?
  16. Count number of unique values
  17. ‘Access denied for user ‘root’@’localhost’ (using password: NO)’
  18. Meaning of “n:m” and “1:n” in database design
  19. How to force case sensitive table names?
  20. MySQL concat() to create column names to be used in a query?
  21. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  22. Count with IF condition in MySQL query
  23. How to format number with “.” as thousands separator and “,” as decimal separator?
  24. Using DISTINCT and COUNT together in a MySQL Query
  25. Error installing mysqlclient for python on Ubuntu 18.04
  26. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  27. Xampp-mysql – “Table doesn’t exist in engine” #1932
  28. Unserialize through query at database level itself
  29. Detecting utf8 broken characters in MySQL
  30. django cannot connect mysql in docker-compose

Leave a Comment