数据库中检测某个字段是否有特殊字符
1、检查是否包含空格或者tab
select * from student where regexp_like(name,'[:blank:]')
2、检查是否有任何标点符号
select * from student where regexp_like(name,'[:punct:]')
3、检查部分特殊字符
select id,spe_char from(select id,regexp_replace(id,'[^!@#$%&*()+=:;",.?\|]','') spe_char from student) t where t.spe_char is not null