mysql字段脱敏

 select

     CONCAT(LEFT(__T1.id_no,6), '****' ,RIGHT(__T1.id_no,4)) as id_no_tm,

    CONCAT(LEFT(__T1.phone,3), '******',RIGHT(__T1.phone,2) ) as phone_tm

from
db1