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

回覆文章
yehlu
Site Admin
文章: 3245
註冊時間: 2004-04-15 17:20:21
來自: CodeCharge Support Engineer

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%'
回覆文章

回到「MySQL」