sql语句实现隐藏手机号码中间四位的方法

1､select REPLACE(mobile,SUBSTR(mobile,4,4), '****') as mobile from tableName

2､select INSERT(mobile, 4, 4, '****') as mobile from tableName ;