Order by numerics then alphas

from the Artful Common Queries page


Given a column type with values 1,2,3,a,b,c, how to get the order 3,2,1,c,b,a?
ORDER BY type RLIKE '^[0-9]+$' DESC, `type` DESC 

Return to the Artful Common Queries page