--LoginIdの「ecadmin」を「ct21admin」に変更 --GroupCodeの「ecmaster」を「ct21master」に変更 UPDATE ctxLoginF SET LoginId = REPLACE(LoginId, 'ec', 'ct21') , GroupCode = REPLACE(LoginId, 'ec', 'ct21') WHERE LoginId LIKE 'ct21%' AND GroupCode LIKE 'ct21%' --GroupCodeの「ecmaster」を「ct21master」に変更 UPDATE ctxGroupM SET GroupCode = REPLACE(GroupCode, 'ec', 'ct21') WHERE GroupCode LIKE 'ct21%'