title: Changing year in mysql date
body: <p>I have a bunch of dates in our database stored in the standard mysql date type. </p>
  
  <p>How can I covert a year to 2013, regardless of original date. </p>
  
  <p>So if a date is 2009-01-01 it would be 2013-01-01, but if it's 2012-01-04, it'd convert to 2013-01-14.</p>
  
  <p>I figured it'd be simple and obvious, but I couldn't figure it out =/</p>