mysql中varchar字段的字符按照数字排序

解决

方法1：

1	select * from test order by score-0 asc;

方法2：

1	select * from test order by cast(score as signed ) asc;

方法3：

1	select * from test order by convert(score,signed) asc;

方法4（亲测有效）：

1	select * from test order by substr(score from 2)-0 asc;