title: mysql find/replace string in fields
body: <p>I have a table which has a few varchar fields named like this:  </p>
  
  <p>image_fullres | image_highres | image_mediumres | image_lowres | image_thumbnail  </p>
  
  <p>I currently have the same value for each of these fields(differing by row), so <strong>image_fullres</strong> has the same path as <strong>image_lowres</strong> and so on.</p>
  
  <p>an example value for these paths would be <code>http://mysite.com/images/image1.jpg</code>  </p>
  
  <p>I would like to have each of these fields to contain a different and appropriate path name, so:</p>
  
  <ul>
  <li><strong>image_fullres</strong> has value of <strong>http://mysite.com/images/fullres/image1.jpg</strong></li>
  <li><strong>image_highres</strong> has value of <strong>http://mysite.com/images/highres/image1.jpg</strong></li>
  <li><strong>image_mediumres</strong> has value of <strong>http://mysite.com/images/mediumres/image1.jpg</strong></li>
  </ul>
  
  <p>and so on...</p>
  
  <p>Since all of my data is already in the database with duplicate paths by row, what SQL can I execute that would change the value of each field's data to an appropriate path?</p>