身份证加*

CREATE DEFINER=`root`@`%` FUNCTION `getIdCardTM`(idCard VARCHAR(255)) RETURNS varchar(1000) CHARSET utf8
    COMMENT '证件号脱敏'
BEGIN
    DECLARE vrerur VARCHAR(255);
    SET vrerur = INSERT ( INSERT ( INSERT ( idCard, 18, 1, '*' ), 4, 5, '*****' ), 10, 7, '*******' );
RETURN vrerur; 
END