数据库查询时，姓名、身份证号、手机号脱敏及字符串替换

最新推荐文章于 2024-07-07 07:59:57 发布

koko、

最新推荐文章于 2024-07-07 07:59:57 发布

阅读量1.2k

点赞数

分类专栏： mysql 文章标签：数据库

本文链接：https://blog.csdn.net/private_name/article/details/121774366

版权

mysql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

sql：

SELECT
        t1.img_url,
        CONCAT(
        LEFT ( t1.NAME, 1 ),
        '*',
        RIGHT ( t1.NAME, CHAR_LENGTH( t1.NAME ) - 2 )
        ) AS uname,
        REPLACE ( t1.borth_month, '.', '-' ) AS borth_month,
        REPLACE ( t1.work_date, '.', '-' ) AS work_date,
        t1.gender,
        concat( t2.NAME, t3.NAME, t4.NAME ) AS home_addr,
        t1.belong_unit,
        t1.certificate_type,
        t1.native_place,
        CONCAT( LEFT ( t1.phone, 3 ), '****', RIGHT ( t1.phone, 4 ) ) AS phone,
        CONCAT( LEFT ( t1.idcard_number, 6 ), '********', RIGHT ( t1.idcard_number, 4 ) ) AS idcard_number,
        t1.teacher_code,
        t1.education_last_level_name,
        t1.education_last_school,
        t1.now_main_subject
        FROM
        bigdata_teacher t1
        LEFT JOIN t_region t4 ON t4.type = 4
        AND LEFT ( t1.idcard_number, 6 ) = t4.
        CODE LEFT JOIN t_region t3 ON t3.type = 3
        AND t4.pid = t3.id
        LEFT JOIN t_region t2 ON t2.type = 2
        AND t3.pid = t2.id

结果：