mysql-批量替换字符串(replace)

批量替换mysql一个表中某个字段的值里面的部分字符串，使用mysql replace函数

# 1.备份表
CREATE TABLE xt_mbfwpz_bak_sjb AS SELECT * FROM xt_mbfwpz;

# 2.批量替换字符
UPDATE xt_mbfwpz SET target_url = REPLACE (
    target_url,   --- field
    '10.x',    --- oldchar
    '10.y'   --- newchar
  );

SELECT * FROM xt_mbfwpz;