title: MySQL RegExp Replace
body: <p>Here is my situation:</p>
  
  <p>My company hosts multiple sites for clients, and the content of the sites are stored in a MySQL database.</p>
  
  <p>I have an issue where I need to go through the whole database and replace pieces of the content.  For example:</p>
  
  <p>I need to replace <strong>http://downloads.mysever.com/siteID/someImage.jpg</strong> with <strong>//downloads.mysever.com/siteID/someImage.jpg</strong></p>
  
  <p>So I just need to remove the <strong>http:</strong> from all links that are going to our downloads server.</p>
  
  <p>My question is what would be the best way to go about this?  Will I need to write a php script to handle this, or am I able to use just MySQL to accomplish this.</p>
  
  <p>Thanks</p>