復制代碼 代碼如下:

UPDATE table SET field = replace(field,'被替換','替換成') 

復制代碼 代碼如下:

UPDATE table SET field = replace(field,'被替換1','替換成1'),field = replace(field,'被替換2','替換成2')