字符串替换

Question

举个例子：
id   content
1    qqqqqbbsdsfsdf english/image/logo/1.jpg sadfsafasjlfkewlfks english/image/logo/2.jpg
2    qqqqqbb english/image/logo/1.jpg 
3    qqqqqbbsdsfsdf english/image/logo/3.jpg asfsadf english/image/logo/4.jpg
4    english/image/logo/4.jpg asdfasdfasfasdf
5    english/image/logo/5.jpg我想把id为1，3，4的content里的english/image/字符串换成 qq/,有什么办法呢？

Answer 1

replace(content,'english/image/','qq/')

Answer 2

update table set content=replace(content,'english/image/','qq/')