56,677
社区成员
发帖
与我相关
我的任务
分享
mysql> set @x='12345';
Query OK, 0 rows affected (0.00 sec)
mysql> select @x,replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(@x,
-> '1','一'),
-> '2','二'),
-> '3','三'),
-> '4','四'),
-> '5','五'),
-> '6','六'),
-> '7','七'),
-> '8','八'),
-> '9','九'),
-> '0','零') as k;
+-------+------------+
| @x | k |
+-------+------------+
| 12345 | 一二三四五 |
+-------+------------+
1 row in set (0.00 sec)
mysql>