SELECT
phone,
concat(
substring(phone, 1, 3),
'****',
substring(phone, 8, 4)
) phone_new
FROM
dw_user
WHERE
phone IS NOT NULL
AND phone <> ''
LIMIT 100,
5
phone,
concat(
substring(phone, 1, 3),
'****',
substring(phone, 8, 4)
) phone_new
FROM
dw_user
WHERE
phone IS NOT NULL
AND phone <> ''
LIMIT 100,
5