将手机号中间4位替换为*****
UPDATE login_info SET phone = REPLACE(phone,SUBSTR(phone,4,4),'****') WHERE phone REGEXP '^1[0-9]{10}$'
UPDATE login_info SET phone = INSERT(phone,4,4,'****') WHERE phone REGEXP '^1[0-9]{10}$'
原始:13773005656
结果:137****5656
mysql的下标从1开始