Mysql加密身份證号

update test set id_no=replace(id_no,substring(id_no,9,14), concat(‘000000’,substring(id_no,15,18)) );