Mysql 字符+数字组合排序
排序前:
// 排序后
SELECT CODE FROM sm_param WHERE CODE LIKE 'MODULE_%' order by cast(substring(code,8) as unsigned );
// 排序后
SELECT CODE FROM sm_param WHERE CODE LIKE 'MODULE_%' order by cast(substring(code,8) as unsigned );