title: select part of table column data in mysql
body: <p>I have a table 'photo' which contains 2000 entries. That table has a column called <code>photo_note</code> which contains data in the format below but with different magnification value.</p>
  
  <pre><code>Magnification 30x. The resolution varies depending on.....
  </code></pre>
  
  <p>I need to select the rest of the column data starting with 'The resolution' and append it in another field 'photo_note_2'</p>
  
  <p>Any suggestion how to do this in mysql is most appreciated</p>