--レコード内のエイリアス指定を更新する UPDATE ctaBannerRoboT SET Description = Replace(Description, '/ec/', '/cybertrade/') UPDATE ctdItemM SET ItemImage = Replace(ItemImage, '/ec/', '/cybertrade/') UPDATE cthPTenantM SET ShopImage = Replace(ShopImage, '/ec/', '/cybertrade/') , ForeImage = Replace(ForeImage, '/ec/', '/cybertrade/') , BackImage = Replace(BackImage, '/ec/', '/cybertrade/') , GuideImage = Replace(GuideImage, '/ec/', '/cybertrade/') UPDATE cthPTenantTItem SET ItemImage = Replace(ItemImage, '/ec/', '/cybertrade/') , SalesImage1 = Replace(SalesImage1, '/ec/', '/cybertrade/') , SalesImage2 = Replace(SalesImage2, '/ec/', '/cybertrade/') , SalesImage3 = Replace(SalesImage3, '/ec/', '/cybertrade/') , SalesImage4 = Replace(SalesImage4, '/ec/', '/cybertrade/') , SalesImage5 = Replace(SalesImage5, '/ec/', '/cybertrade/') UPDATE ctpPracticeM SET BgImage = Replace(BgImage, '/ec/', '/cybertrade/') UPDATE ctpTownT SET BgImage = Replace(BgImage, '/ec/', '/cybertrade/') , TramImage = Replace(TramImage, '/ec/', '/cybertrade/') , RoadImage = Replace(RoadImage, '/ec/', '/cybertrade/') , ShopImage0 = Replace(ShopImage0, '/ec/', '/cybertrade/') , ShopImage1 = Replace(ShopImage1, '/ec/', '/cybertrade/') , ShopImage2 = Replace(ShopImage2, '/ec/', '/cybertrade/') , ShopImage3 = Replace(ShopImage3, '/ec/', '/cybertrade/') , ShopImage4 = Replace(ShopImage4, '/ec/', '/cybertrade/') , ShopImage5 = Replace(ShopImage5, '/ec/', '/cybertrade/') UPDATE ctpTradeTrn SET ItemImage = Replace(ItemImage, '/ec/', '/cybertrade/') UPDATE ctsCodeTS SET directory = Replace(directory, '/ec/', '/cybertrade/') UPDATE ctsCodeTSgif SET IdentName = Replace(IdentName, '/ec/', '/cybertrade/')