56,677
社区成员
发帖
与我相关
我的任务
分享
mysql> set @x='111-(444)-789';
Query OK, 0 rows affected (0.00 sec)
mysql> select replace(replace(replace(replace(replace(replace(replace(replace(re
place(replace(@x,'0','*'),'1','*'),'2','*'),'3','*'),'4','*'),'5','*'),'6','*'),
'7','*'),'8','*'),'9','*') as nx;
+---------------+
| nx |
+---------------+
| ***-(***)-*** |
+---------------+
1 row in set (0.00 sec)
mysql>