使用mysql将姓名、手机号、身份证号等敏感字段替换成*号

-- 脱敏 姓名
UPDATE art_user SET nick_name = IF(LENGTH(nick_name) > 6, CONCAT(LEFT(nick_name, 1), '**'), CONCAT(LEFT(nick_name, 1), '*'));

-- 脱敏 手机号
UPDATE art_user SET phone = IF(ISNULL(phone) OR phone = '', NULL, CONCAT(LEFT(phone, 3), '*****', RIGHT(phone, 3)));

-- 脱敏 邮箱
UPDATE art_user SET email = IF(ISNULL(email) OR email = '', NULL, CONCAT('***', substring(email, INSTR(email, '@'))));

-- 脱敏 身份证号
UPDATE art_real_auth SET id_number = CONCAT(LEFT(id_number, 4), '************', RIGHT(id_number, 2));

转载请注明出处：BestEternity亲笔。