title: mySql query search and replace
body: <p>Hey folks, I have a field within a table that I need to do a search and replace on, though it's a bit tricky and beyond my measure of querying skills. Basically, the contents of a field may look like this:</p>
  
  <pre><code>image1.jpg
  image2.jpg
  image3.jpg
  image4.jpg
  image5.jpg
  </code></pre>
  
  <p>I need to do a search and replace that would replace each line with something like:</p>
  
  <pre><code>&lt;img src="http://www.domain.com/image1.jpg" /&gt;
  &lt;img src="http://www.domain.com/image2.jpg" /&gt;
  &lt;img src="http://www.domain.com/image3.jpg" /&gt;
  &lt;img src="http://www.domain.com/image4.jpg" /&gt;
  &lt;img src="http://www.domain.com/image5.jpg" /&gt;
  </code></pre>
  
  <p>The image titles are completely random and could be .gif, .jpg or pngs. The table name is "exp_channel_data" and the field name is "field_id_8" and I'd be running the query in phpadmin. Is the above search and replace possible?</p>