1、字符串转Integer SELECT CAST (title as integer) FROM xxx where code='-1'; 2、字符串转整型之后排序 ordey by cast(unit as integer)