title: Adding a leading zero to some values in column in MySQL
body: <p>I have a CSV file sent to me in CSV. The field of interest is 8 digits. Some of those started with a 0. The field was sent numeric. So, I now have dropped some leading zeros.</p>
  
  <p>I already converted the field to varchar. I now need to do this:</p>
  
  <p>I have this now:</p>
  
  <pre><code>12345678
  1234567
  </code></pre>
  
  <p>I need to have this:</p>
  
  <pre><code>12345678
  01234567
  </code></pre>