title: WordPress media library, change existing URLS to AWS s3
body: <p>I am having trouble mass changing the locations in WordPress for the images. </p>
  
  <p>I have ran this request in PHPMyAdmin</p>
  
  <pre><code>UPDATE wp_posts SET guid = replace(guid, ‘http://www.oldsite.com’,’http://www.newsite.com’);
  UPDATE wp_posts SET post_content = replace(post_content, ‘http://www.oldsite.com’, ‘http://www.newsite.com’);
  UPDATE wp_postmeta SET meta_value = replace(meta_value, ‘http://www.oldsite.com’, ‘http://www.newsite.com’);
  </code></pre>
  
  <p>Where <strong>newsite.com</strong> is the url for the S3 bucket. </p>
  
  <p>However, when I go into the media library for wordpress none of the images are loading. When I click an image, the URL for that image is still <strong>oldsite.com/wp-content/uploads/...</strong></p>
  
  <p>Can someone please help me make wordpress media manager use my s3 url instead?</p>
  
  <p>p.s I have just over 12 thousand images. Would ideally not want to do this manually.</p>