显示所有字段+单独显示手机字段(左边3个字符)+******+右边3个字符 SELECT phone,CONCAT(left(phone,3),'*****',right(phone,3)) as fmt_phone FROM `user`