【MySQL】手机号脱敏查询

2019-12-27 本文已影响0人嗖嗖编程

SELECT

CONCAT(LEFT(phone, 3), '****' , RIGHT(phone, 4)) AS phone

FROM table;