mysql中获取varchar类型数据的最大值

select MAX(CAST(userNo as SIGNED INTEGER)) from userInfo ;

或者

select MAX(CAST(userNo as UNSIGNED INTEGER)) from userInfo ;

————varchar 转 int 

cast(id as signed integer)  或者 cast(id as unsigned integer)