mysql身份证号脱敏:
(CASE WHEN people.idcard_no !='' THEN CONCAT(LEFT(people.idcard_no,6), '******' ,RIGHT(people.idcard_no,2)) ELSE '' END) idcard_no
mysql手机号脱敏:
CASE WHEN (ISNULL(people.mobile)=0) and (LENGTH(trim(people.mobile))>0) THEN CONCAT(LEFT(people.mobile,3), '****' ,RIGHT(people.mobile,4)) else '' END AS mobile