日期:2014-05-16  浏览次数:20758 次

mysql 使用 replace 命令批量替换

mysql> select * from test1;

+------+---------+

| id ? | name ? ?|

+------+---------+

| ? ?1 | aaaKaaa |

| ? ?2 | bbbKbbb |

| ? ?3 | cccKccc |

+------+---------+

3 rows in set (0.00 sec)

?

mysql> update test1 set name=replace(name,'K','211.99.224.138');

Query OK, 3 rows affected (0.01 sec)

Rows matched: 3 ?Changed: 3 ?Warnings: 0

?

mysql> select * from test1;

+------+----------------------+

| id ? | name ? ? ? ? ? ? ? ? |

+------+----------------------+

| ? ?1 | aaa211.99.224.138aaa |

| ? ?2 | bbb211.99.224.138bbb |

| ? ?3 | ccc211.99.224.138ccc |

+------+----------------------+

3 rows in set (0.00 sec)