mysql 身份号脱敏

update patient set cert_number=REPLACE(cert_number,SUBSTR(cert_number FROM 7 FOR 8),'*********')
where cert_number is not null  and locate(cert_number,'*') = 0