SELECT
CONCAT(
SUBSTRING(telephone, 1, 4),
'***',
SUBSTRING(telephone, 8, 4)
) AS 电话号码,
cfniiu_userid AS '财富牛用户ID',
LEFT(cfniu_regDate,19) AS '在财富牛注册时间',
9niu_userid AS '9牛用户ID',
LEFT(9niu_regDate,19) AS '在9牛注册时间'
FROM
`cfniu9niu_duplicate`
-- SUBSTRING(telephone, 1, 4):字符串截取,1,第一个位置开始,4:长度为4
-- CONCAT(A,B,C)相当于字符串连接:A+B+C
CONCAT(
SUBSTRING(telephone, 1, 4),
'***',
SUBSTRING(telephone, 8, 4)
) AS 电话号码,
cfniiu_userid AS '财富牛用户ID',
LEFT(cfniu_regDate,19) AS '在财富牛注册时间',
9niu_userid AS '9牛用户ID',
LEFT(9niu_regDate,19) AS '在9牛注册时间'
FROM
`cfniu9niu_duplicate`
-- SUBSTRING(telephone, 1, 4):字符串截取,1,第一个位置开始,4:长度为4
-- CONCAT(A,B,C)相当于字符串连接:A+B+C