SQL
[root@localhost:mysql3306.sock] [atm]> select id,username,concat(left(tel,3),"****",right(tel,4)) AS telnum from user where username='zhouwanchun'; +----+-------------+-------------+ | id | username | telnum | +----+-------------+-------------+ | 1 | zhouwanchun | 151****5139 | +----+-------------+-------------+ 1 row in set (0.00 sec)