Update a column value, replacing part of a string

Source: https://stackoverflow.com/questions/10177208/update-a-column-value-replacing-part-of-a-string

UPDATE urls
SET url = REPLACE(url, 'domain1.com/images/', 'domain2.com/otherfolder/')

Very useful, worked on 2000 queries with out fail, very quickly. – Andy Dec 14 '16 at 18:05
• 4
  REPLACE also works on SELECTs, quite useful :) – Arda Apr 19 '17 at 10:20