How can I use mySQL replace() to replace strings in multiple

[yehlu]

http://stackoverflow.com/questions/4271 ... le-records

代碼: 選擇全部

UPDATE indexs

SET content = REPLACE (content, 'http://mass-age', 'http://www.mass-age')

WHERE content LIKE '%http://mass-age%'