SQL replace record replacement notes

Here we use the SQL replace function to operate the dedecms database. Now I want to change the image address litpic OF THE dedecms database and the address in introduce to an operation note for a second-level domain name address, if you need it, you can check it out.

The following is a database tutorial using the SQL replace function to operate dedecms. I want to change the image address litpic OF THE dedecms database and the address in introduce to the Operation Note of a second-level domain name address, if you need it, you can check it out.
Http://upload.bKjia. c0m/image/201001302300192.jpg

Update 'd _ archives 'set litpic = replace (litpic, 'HTTP: // g.111cn.cn ', 'HTTP: // upload. bKjia. c0m') where id = 13696

Http://down.bKjia. c0m/uploads/allimg/101029/1 _21232xj3.jpg

=

Http://upload.bKjia. c0m/allimg/101029/1 _21232xj3.jpg

Http://down.bKjia. c0mhttp: // upload. bKjia. c0m/101117/1 _093843_1.png

//

Select * from d_addonsoft where 'inserted' like '% http://down.bKjia. c0m/uploads/%'

Update 'd _ archives 'set litpic = replace (litpic, 'HTTP: // down. bKjia. c0mhttp: // ', 'HTTP: //') where id = 8470

This site original tutorials reprinted indicated from http://www.bKjia. c0m otherwise required