对表中敏感信息身份证号、手机号、邮箱进行***加密处理
身份证
UPDATE student set SFZ=REPLACE(SFZ,SUBSTRING(SFZ,11,8),concat('********'));
手机
UPDATE student set PHONE=REPLACE(PHONE,SUBSTRING(PHONE,8,4),concat('****'));
邮箱
UPDATE student set EMAIL=REPLACE(EMAIL,SUBSTRING(EMAIL,1,4),concat('****'));
效果