mysql⾝份证号的类型_MySQL--隐藏⼿机号、⾝份证号三种⽅
式
测试数据汉字urlencode
SELECTsortedlist
*
FROM
`userinfo`;
⽅式⼀(最推荐)
SELECT
`name` AS '姓名',
INSERT ( telephone, 4, 4, '****' ) AS '⼿机号',
woshop商城源码
INSERT ( cardID, 4, 11, '***********' ) AS '⾝份证号'
FROM
userinfo;floating point number
imfilter函数用法⽅式⼆
SELECT
`name` AS '姓名',
REPLACE ( telephone, SUBSTR( telephone, 4, 4 ), '****' ) AS '⼿机号',
REPLACE ( cardID, SUBSTR( cardID, 4, 11 ), '***********' ) AS '⾝份证号'
FROM
userinfo;
⽅式三
SELECT
`name` AS '姓名',
手机mysql安装配置教程CONCAT_WS( '', SUBSTR( telephone, 1, 3 ), '****', SUBSTR( telephone, 8, 4 ) ) AS '⼿机号',
CONCAT_WS( '', SUBSTR( cardID, 1, 3 ), '***********', SUBSTR( cardID, 15, 4 ) ) AS '⾝份证号'
FROM
userinfo;

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。