隐藏手机号操作

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

posted @ 2019-03-09 16:27  yikuandyk  阅读(198)  评论(0编辑  收藏  举报