Mysql 字符+数字组合排序

Mysql 字符+数字组合排序

排序前：

// 排序后
SELECT CODE FROM sm_param WHERE CODE LIKE 'MODULE_%' order by cast(substring(code,8) as unsigned );