title: MySQL adding leading numbers to existing IDs in a column
body: <p>I got a mysql database column named country_id, like:</p>
  
  <pre><code>country_id
  ----------
  1
  2
  59
  435
  2714
  </code></pre>
  
  <p>What I'm trying to accomplish now is to add leading zero's to each ID, so the result would be:</p>
  
  <pre><code>country_id
  ----------
  0001
  0002
  0059
  0435
  2714
  </code></pre>
  
  <p>Each ID should have max 4 digits. That's it.</p>
  
  <p>Is there any SQL statement I could use in PHPmyAdmin to update this country_id column in the way described above? </p>
  
  <p>Best regards!</p>