实现数字加字母的组合排序（"AA","A1","A2","A3","A4","BB","B1","B2","B3","B4","CC","C1","C2","C3","C4"）

1.将字母排在前面数字排下后面

ORDER BY nameRight regexp '^[0-9]',space desc

2.排序完整sql的demo

select name,left(name,1) nameLeft,right(name,1) nameRight 
from store 
ORDER BY nameLeft,nameRight regexp '^[0-9]',convert(name using gbk),space desc