隐藏手机号操作

oracle:select user_name, substr(mobile,1,3)||'*****'||substr(mobile,-3,4) from t_cust_user

mysql:select user_name, concat(left(mobile,3),'*****',right(mobile,3)) from t_cust_user

原文地址:https://www.cnblogs.com/yikuan-919/p/10501738.html