update XF_VIP set XF_SURNAME = REPLACE(XF_SURNAME,'定金','订金') where XF_VIPCODE = 'CRR0000000'; SQL> update XF_VIP set XF_SURNAME = REPLACE(XF_SURNAME,'定金','订金') where XF_SURNAME LIKE '%定金%';