Try this
SELECT * FROM table_name ORDER BY CAST(field_name as SIGNED INTEGER) ASC
More Related Contents:
- How to find similar results and sort by similarity?
- Mysql: Select rows from a table that are not in another
- Mysql order by specific ID values
- MySQL: Sort GROUP_CONCAT values
- ORDER BY date and time BEFORE GROUP BY name in mysql
- updating columns with a sequence number mysql
- mysql sorting of version numbers
- is php sort better than mysql “order by”?
- mysql custom sort
- ORDER BY alphabet first then follow by number
- Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)
- MySQL – Get row number on select
- How to use GROUP_CONCAT in a CONCAT in MySQL
- MySQL query / clause execution order
- Operand Should Contain 1 Column – MySQL NOT IN
- Error Code: 1005. Can’t create table ‘…’ (errno: 150)
- Error 1022 – Can’t write; duplicate key in table
- Are nested transactions allowed in MySQL?
- SQL Query to get column values that correspond with MAX value of another column?
- MySQL : transaction within a stored procedure
- MySQL – How to search for exact word match using LIKE?
- Implementing a hierarchical data structure in a database
- MySQL date format
- How to get current date & time in MySQL?
- How do I split the output from mysqldump into smaller files?
- MySQL Group By Hours
- DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
- Incorrect key file for table ‘/tmp/#sql_3c51_0.MYI’; try to repair it [duplicate]
- Escape line breaks in MySQL output
- MySQL Relationships