话不多说直接上sql,这里切记,是utf8编码格式的 select DISTINCT A00 FROM A36 WHERE A3601 IS NOT NULL AND (char_length(A3601)*3!=length(A3601) OR char_length(A3601)<2)