查询表table_name中col_name(字符串类型)的值是数字的记录 select col_name,cast(col_name as unsigned integer) as val from table_name where col_name=0 or col_name0 having char_length(col_name)=char_length(val); 查询表table_name中col_name(字符串类型)的值是数字的记录 select col_name,cast(col_name as unsigned integer) as val from table_name where col_name=0 or col_name>0 having char_length(col_name)=char_length(val);