I have a table with the following columns in a MySQL database
And the urls are like:
I want to update all the urls to another domain
keeping the name of the file as is.
What’s the query must I run?
UPDATE urls SET url = REPLACE(url, 'domain1.com/images/', 'domain2.com/otherfolder/')
Answered By – Dmytro Shevchenko
Answer Checked By – Marilyn (BugsFixing Volunteer)