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