-- 脫敏姓名
UPDATE?wb_person_message?SET?`name`=(if(LENGTH(name)>6,CONCAT(LEFT(name,1),?'**'?),CONCAT(LEFT(name,1),?'*'?)));
-- 脫敏身份證號
UPDATE?wb_person_message?SET?idNumber=CONCAT(LEFT(idNumber,4),?'************'?,RIGHT(idNumber,2));
-- 脫敏學(xué)歷
update?wb_person_message?set?education =?'博士',university =?'清華大學(xué)',specialities='計算機科學(xué)與技術(shù)';
-- 脫敏手機號
UPDATE?wb_person_message?set?phone = CONCAT(LEFT(phone,3),?'*****'?,RIGHT(phone,3));
-- 查詢結(jié)果
SELECT?name,idNumber,phone,education,university,specialities?from?wb_person_message;
