UPDATE WJBD_DXYY_ZQMBQJZX.WJBD_ZBZQ_MB_DW SET IMG = REPLACE(IMG, '/dataUrl/', '/alldata04Url/') WHERE TARGET_ID = '你的TARGET_ID' AND IS_DELETED = 0 AND IMG LIKE '/dataUrl/%'; COMMIT;