下面我們是利用sql replace函數來操作dedecms 的數據庫教程,我現在是把dedecms 數據庫的圖片地址litpic,introduce中的地址換成一個二級域名地址的操作筆記,有需要的朋友可以看一下。
http://upload.111cn.net/image/201001302300192.jpg
update `d_archives` set litpic = replace(litpic,'http://g.111cn.net','http://upload.111cn.net') where id=13696
http://down.111cn.net/uploads/allimg/101029/1_21232xj3.jpg
==
http://upload.111cn.net/allimg/101029/1_21232xj3.jpg
http://down.111cn.nethttp://upload.111cn.net/101117/1_093843_1.png
//
select * from d_addonsoft where `introduce` like '%http://down.111cn.net/uploads/%'
update `d_archives` set litpic = replace(litpic,'http://down.111cn.nethttp://','http://') where id=8470
本站原創教程轉載注明來源於http://www.111cn.net 否則必究