title: Update a column value, replacing part of a string
body: <p>I have a table with the following columns in a MySQL database</p>
  <pre><code>[id, url]
  </code></pre>
  <p>And the URLs are like:</p>
  <pre><code> http://domain1.example/images/img1.jpg
  </code></pre>
  <p>I want to update all the URLs to another domain</p>
  <pre><code> http://domain2.example/otherfolder/img1.jpg
  </code></pre>
  <p>keeping the name of the file as is.</p>
  <p>What's the query must I run?</p>