mysql 排序 数字排后面,按字母顺序对MySQL结果进行排序，但最后一个数字

Often, sorting is done with symbols sorted to the top, like 0 or * or &. This is the default way that mysql sorts; numbers and symbols and then A-Z. However, that makes the often ugliest or most badly formatted results float to the top (e.g. a result of @#$@3423 or 8 inch or &amp).

So I'd like to do a modified form of that, letters first A-Z, and then special characters last.

How would I go about creating that type of sort? Something in the ORDER BY clause?

解决方案

EDIT: Original link is dead.

Here is another link which actually explains what is happening better than the first link did:

You might try this

SELECT names FROM your_table ORDER BY names + 0 ASC