Çʵ嵥ÀÌŸ¸¦ º¯°æÇØÁÖ´Â ¹æ¹ýÀÔ´Ï´Ù.
# REPLACE(Çʵå¸í, ¼öÁ¤Àü ¹®ÀÚ¿, ¼öÁ¤ÈÄ ¹®ÀÚ¿)
³ª°°Àº °æ¿ì´Â µ¥ÀÌŸ¿¡ ÀúÀåµÈ ¾ÆÀÌÇǸ¦ ³×Æ®¿öÅ© ´ë¿ªÀ» º¯°æÇϱâ À§ÇØ »ç¿ëÇß´Ù.
mysql> update 130_policy set server_ip=replace(server_ip,'xxx.xxx.121','xxx.xxx.252');
Query OK, 18 rows affected (0.04 sec) Rows matched: 18 Changed: 18 Warnings: 0
mysql> update 130_policy set destination_ip=replace(destination_ip,'xxx.xxx.121','xxx.xxx.252');
Query OK, 17 rows affected (0.00 sec) Rows matched: 18 Changed: 17 Warnings: 0 |