title: Find and replace string with placeholders in SQL
body: <p>Is it possible to search for a string like this:</p>
  
  <pre><code>http://getfile1.posterous.com/getfile/files.posterous.com/temp-2013-03-30/kBpHaviyoumcvCEHnGnrDfwHwmJIrnqrHrxhCnHwfBIHuDsxbemHlxwEwCdi/IMG_6870.jpg
  </code></pre>
  
  <p>while some parts are placeholders like:</p>
  
  <pre><code>http://getfile%.posterous.com/getfile/files.posterous.com/temp-2013-03-%/%/IMG_6870.jpg
  </code></pre>
  
  <p>and replace it with:</p>
  
  <pre><code>http://my.domain.com/wordpress/wp-content/uploads/2013/03/IMG_6870.jpg
  </code></pre>
  
  <p>Thank you for inputs!</p>