title: SQL blob modification with regexp
body: <p>I have a table with a blob column containing serialized data like this:</p>
  
  <pre><code>a:3:{i:0;s:69:"http://example.com/uploads/program/13/image1.jpg";
  i:1;s:69:"http://example.com/uploads/program/13/image2.jpg";
  i:2;s:69:"http://example.com/uploads/program/13/image3.jpg";}
  </code></pre>
  
  <p>I need to subtract 3 from each <code>s:[0-9]{2}</code>. How can this be accomplished for the whole table in MySQL?</p>