数据库中网址替换

发布时间：2016-01-22 11:16:22编辑：丝画阁阅读（217）

UPDATE destoon_ad_place SET thumb = REPLACE(thumb,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_announce SET linkurl = REPLACE(linkurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_article_data_21 SET content = REPLACE(content,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_brand SET thumb = REPLACE(thumb,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_comment SET item_linkurl = REPLACE(item_linkurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_favorite SET url = REPLACE(url,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_gift SET thumb = REPLACE(thumb,'www.miaomu.net','news.ftxk.cn'),linkurl = REPLACE(linkurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_honor SET thumb = REPLACE(thumb,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_know_answer SET linkurl = REPLACE(linkurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_link SET thumb = REPLACE(thumb,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_mall SET thumb = REPLACE(thumb,'www.miaomu.net','news.ftxk.cn'),thumb1 = REPLACE(thumb1,'www.miaomu.net','news.ftxk.cn'),thumb2 = REPLACE(thumb2,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_message SET content = REPLACE(content,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_module SET linkurl = REPLACE(linkurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_news SET linkurl = REPLACE(linkurl,'hxqlmm.miaomu.net','news.ftxk.cn');
UPDATE destoon_photo SET thumb = REPLACE(thumb,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_photo_item SET thumb = REPLACE(thumb,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_resume SET thumb = REPLACE(thumb,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_upload_0 SET fileurl = REPLACE(fileurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_upload_1 SET fileurl = REPLACE(fileurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_upload_2 SET fileurl = REPLACE(fileurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_upload_3 SET fileurl = REPLACE(fileurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_upload_4 SET fileurl = REPLACE(fileurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_upload_5 SET fileurl = REPLACE(fileurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_upload_6 SET fileurl = REPLACE(fileurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_upload_7 SET fileurl = REPLACE(fileurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_upload_8 SET fileurl = REPLACE(fileurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_upload_9 SET fileurl = REPLACE(fileurl,'www.miaomu.net','news.ftxk.cn');
UPDATE destoon_validate SET thumb = REPLACE(thumb,'www.miaomu.net','news.ftxk.cn');