mysql对姓名 手机号 身份证号做脱敏处理

SELECT #phone手机号脱敏处理IF( phone='', '', CONCAT(LEFT(phone, 3), '****', RIGHT(phone,4))) AS dephone,#cardno身份证号脱敏处理IF( cardno='', '', CONCAT(LEFT(cardno, 3), '************', RIGHT(phone,4))) AS decardno,#realname姓名脱敏处理CASEWHEN CHAR_LENGTH(realname) = 0 THEN ''WHEN CHAR_LENGTH(TRIM(realname)) = 1 THEN realnameWHEN CHAR_LENGTH(TRIM(realname)) = 2 THEN CONCAT(LEFT(realname, 1),'*')ELSE CONCAT(LEFT(realname, 1),REPEAT('*', CHAR_LENGTH(TRIM(realname)) - 2),RIGHT(realname, 1))END AS derealname FROM biz_user_info;