Update a column value, replacing part of a string
mysql, sql
Solution
UPDATE urls
SET url = REPLACE(url, 'domain1.example/images/', 'domain2.example/otherfolder/')
Problem
I have a table with the following columns in a MySQL database ``` [id, url] ``` And the URLs are like: ``` http://domain1.example/images/img1.jpg ``` I want to update all the URLs to another domain ``` http://domain2.example/otherfolder/img1.jpg ``` keeping the name of the file as is. What's the query must I run?