title: Mysql Preg Replace command
body: <p>thanks for reading.</p>
  
  <p>I have this record for my wordpress media which is of the following text</p>
  
  <pre><code>"wp-content/uploads/2015/03/file.jpg" and many other files e.g
  "wp-content/uploads/2015/03/somestuffs.mp4"
  </code></pre>
  
  <p>I wanna do a mass update on the return record by replacing</p>
  
  <pre><code>2015/03 with 2014/09
  </code></pre>
  
  <p>How do I achieve this with update statement</p>
  
  <p><strong>Thanks!</strong></p>