Sorting varchar field numerically in MySQL

June 9, 2023 by Tarik

Try this

SELECT * FROM table_name ORDER BY CAST(field_name as SIGNED INTEGER) ASC