MySQL 手机号脱敏

select CONCAT(SUBSTRING(phone,1,3),'****',SUBSTRING(phone,8))as phone from table

select replace(phone,SUBSTRING(phone,4,4),'****') as phone from table