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 ;