–1.不包含字母 SELECT * FROM t WHERE str NOT LIKE ‘%[a-zA-Z]%’ SELECT * FROM t WHERE patindex(‘%[a-zA-Z]% … Continue reading sql 找出不包含字母、不包含汉字的数据
–1.不包含字母 SELECT * FROM t WHERE str NOT LIKE ‘%[a-zA-Z]%’ SELECT * FROM t WHERE patindex(‘%[a-zA-Z]% … Continue reading sql 找出不包含字母、不包含汉字的数据