mysql身份证号的类型_MySQL--隐藏手机号、身份证号三种方式

mysql⾝份证号的类型_MySQL--隐藏⼿机号、⾝份证号三种⽅

式

测试数据

SELECT

*

FROM

`userinfo`;

⽅式⼀(最推荐)

SELECT

`name` AS '姓名',

ISERT ( telephone, 4, 4, '****' ) AS '⼿机号',

ISERT ( cardID, 4, 11, '***********' ) AS '⾝份证号'

FROM

userinfo;

⽅式⼆

SELECT

`name` AS '姓名',

REPLACE ( telephone, SUBSTR( telephone, 4, 4 ), '****' ) AS '⼿机号',

REPLACE ( cardID, SUBSTR( cardID, 4, 11 ), '***********' ) AS '⾝份证号'

FROM

userinfo;

⽅式三

SELECT

`name` AS '姓名',

COCAT_WS( '', SUBSTR( telephone, 1, 3 ), '****', SUBSTR( telephone, 8, 4 ) ) AS '⼿机号',

COCAT_WS( '', SUBSTR( cardID, 1, 3 ), '***********', SUBSTR( cardID, 15, 4 ) ) AS '⾝份证号'

FROM

userinfo;