SQL SERVER
方法一:
SELECT * FROM ZP_RESUME WHERE PHONE_NUMBER like '%[吖-座]%'
方法二:
SELECT * FROM ZP_RESUME WHERE not PATINDEX('%[吖-做]%',[PHONE_NUMBER]) = 0
方法三:
SELECT * FROM ZP_RESUME WHERE ascii(PHONE_NUMBER) > 127
MYSQL
方法一:
SELECT * FROM ZP_RESUME WHERE length(PHONE_NUMBER) != char_length(PHONE_NUMBER)
方法二:
SELECT * FROM ZP_RESUME WHERE PHONE_NUMBER REGEXP '[0-9]{1,10}' = 0
方法三:
SELECT * FROM ZP_RESUME WHERE not(PHONE_NUMBER regexp "[\u4E00-\u9FA5]");
ORACLE
方法一:
SELECT * FROM ZP_RESUME WHERE ASCIISTR(PHONE_NUMBER) LIKE '%\%'
方法二:
SELECT * FROM ZP_RESUME WHERE LENGTH(PHONE_NUMBER) != LENGTHB(PHONE_NUMBER);
方法三:
SELECT * FROM ZP_RESUME WHERE PHONE_NUMBER <> CONVERT(PHONE_NUMBER, 'ZHS16GBK', 'UTF8')