Re: [請益] 數字取代
雖然不知道你用的資料庫有沒有這方法...不過我剛用了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
討論串 (同標題文章)
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
