后端手机号脱敏处理

java

String mobile = userTele.replaceAll("(\\d{3})\\d{4}(\\d{4})", "$1****$2");

mysql

CONCAT( LEFT ( t2.USER_TELE, 3 ), '****', RIGHT ( t2.USER_TELE, 4 ) ) AS userTele