利用mysql的CONCAT、LEFT、RIGHT函数实现: SELECT CONCAT(LEFT(phone,3), '****' ,RIGHT(phone,4)) AS phone FROM user;