select * from tbl_active_result order by CAST(`val2` AS DECIMAL) ASC
MySQL 字符串类型按整型排序
最新推荐文章于 2022-06-27 20:00:01 发布
select * from tbl_active_result order by CAST(`val2` AS DECIMAL) ASC