Convert partially non-numeric text into number in MySQL query October 18, 2022 by Tarik This should work: SELECT field,CONVERT(SUBSTRING_INDEX(field,'-',-1),UNSIGNED INTEGER) AS num FROM table ORDER BY num;