--レコード内のエイリアス指定を更新する UPDATE cthPTenantM SET ShopImage = Replace(ShopImage, '/ec/', '/cybertrade/') , ForeImage = Replace(ForeImage, '/ec/', '/cybertrade/') , BackImage = Replace(BackImage, '/ec/', '/cybertrade/') , GuideImage = Replace(GuideImage, '/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/')