title: MySQL: Replace a specific MySQL Value with an SQL Query
body: <p>I have a database with a column 'Date'. </p>
  
  <p>At first, the person whom setup the database, he wrongly set the column Type to varchar(9).</p>
  
  <p>The date's are <strong>01-01-2012 (10 Characters)</strong>, thus on every single date is missing the last number.</p>
  
  <p><img src="https://i.stack.imgur.com/8ZhZk.png" alt="enter image description here"></p>
  
  <p>Is it possible now to replace all 201 with 2012 using a MySQL Query?</p>
  
  <p>Thanks</p>