2020-02-16 标签:替换,一个字,数字,字符,空的,sql,语句,update,mobileno,batchreg,black,set,mobile,n,o,replace

1.替换一个字段的所有非数字字符为空 update mobileNo_batchreg_black set mobile_no= replace( replace( replace( replace( replace( replace( replace( replace( replace( repl