title: How can I change an URL inside a field in MySQL?
body: <p>I have a table called "wp-posts" with a field "post-content". This field contains the text for a blog posts. I'd like to change all records to replace an URL for another one.</p>
  
  <p>Imagine that I can have things like:</p>
  
  <blockquote>
    <p>This is a test and somewhere there's something like &lt;img src="http://<b>oldurl.com</b>/wp-content/somimg.jpg"&gt; and something like &lt;a href="http://<b>oldurl.com</b>/something"&gt;a link&lt;/a&gt;."</p>
  </blockquote>
  
  <p>I want it to be</p>
  
  <blockquote>
    <p>This is a test and somewhere there's something like &lt;img src="http://<b>newurl.com</b>/wp-content/somimg.jpg"&gt; and something like &lt;a href="http://<b>newurl.com</b>/something"&gt;a link&lt;/a&gt;."</p>
  </blockquote>
  
  <p>I need to be able to change this for every record in my table without having to open each post in Wordpress and change them by hand. There has to be a way to do this </p>