dominikbulaj
5/2/2016 - 12:27 PM

Update field in MySQL with new value from original (replacement) From http://stackoverflow.com/questions/10177208/update-a-column-value-rep

Update field in MySQL with new value from original (replacement)

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

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