mysqlvarchar类型转换int类型

select * from tablename order bycast(sid as SIGNED INTEGER)

或者

select * from tablename order bycast(sidas UNSIGNED INTEGER)