MySQL的疑难杂症查询

-- 1、查询字段中包含非数字的行
SELECT * FROM patient WHERE Id NOT REGEXP '^[0-9]+$';
-- 查询包含中文的字符
SELECT weight FROM haidian_clean WHERE length(weight)!=char_length(weight);
-- 查询字段超过长度的
SELECT idcard FROM  WHERE length(idcard) > 18