mysql 查询时 给手机号打码

SELECT CONCAT(LEFT(phone,3), '****' ,RIGHT(phone,4)) AS phone FROM user;