How can I use mySQL replace() to replace strings in multiple
發表於 : 2013-10-09 08:22:55
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%'