mysql的varchar类型转换int类型

select * from gyzd_yysinfo order by cast(yysid as SIGNED INTEGER)

一、手动转化类型(直接+0)

select server_id from cardserver where game_id = 1 order by server_id+0 desclimit 10

二、使用MySQL函数CAST

select server_id from cardserver where game_id = 1 order by CAST(server_id as SIGNED) desc limit 10;

三、使用MySQL函数CONVERT

select server_id from cardserver where game_id = 1 order by CONVERT(server_id,SIGNED)desc limit 10;

四、参考链接

1、mysql varchar类型转换int类型
2、MySQL 函数