作者shadowjohn (3WA问题解决专家)
看板PHP
标题Re: [请益] 数字取代
时间Wed Nov 10 03:59:03 2010
虽然不知道你用的资料库有没有这方法...不过我刚用了mysql有简单的作法
mysql> use test
Database changed
mysql> create table `vvvvv`(`field1` varchar(15));
Query OK, 0 rows affected (0.02 sec)
mysql> insert into `vvvvv`(`field1`)values('20495012252');
Query OK, 1 row affected (0.00 sec)
mysql> insert into `vvvvv`(`field1`)values('53434342223');
Query OK, 1 row affected (0.00 sec)
mysql> select * from `vvvvv`;
+-------------+
| field1 |
+-------------+
| 20495012252 |
| 53434342223 |
+-------------+
2 rows in set (0.01 sec)
mysql> update `vvvvv` set `field1`=replace(`field1`,'2','4');
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> select * from `vvvvv`;
+-------------+
| field1 |
+-------------+
| 40495014454 |
| 53434344443 |
+-------------+
2 rows in set (0.00 sec)
mysql>
--
3WA训练家的工作室
宗旨：诸葛单中，谢谢
个人布弱格 网址：
http://3wa.tw
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 114.32.9.79