C_calary的博客

1、将手机号中间4位替换为*****replace 写法UPDATE login_info SET phone = REPLACE(phone,SUBSTR(phone,4,4),'****') WHERE phone REGEXP '^1[0-9]{10}$'insert写法UPDATE login_info SET phone = INSERT(phone,4,4,'****'...