1、select REPLACE(mobile,SUBSTR(mobile,4,4), '****') as mobile from tableName
2、select INSERT(mobile, 4, 4, '****') as mobile from tableName ;
1、select REPLACE(mobile,SUBSTR(mobile,4,4), '****') as mobile from tableName
2、select INSERT(mobile, 4, 4, '****') as mobile from tableName ;
转载于:https://www.cnblogs.com/yudis/p/6187505.html