title: How to add leading zeros into existing Column?
body: <p>I have one column (<strong>zip varchar(10)</strong>) in MySQL.<BR>
  I am giving some value examples of this columns. <BR><BR></p>
  
  <p><strong>1.</strong> 576<BR>
  <strong>2.</strong> 5768<BR>
  <strong>3.</strong> 57689<BR><BR></p>
  
  <p>I want to replace all three digits with adding <strong>00</strong> as prefix, all four digits with adding <strong>0</strong> prefix. <BR>
  So after doing this operation my values should be,<BR><BR></p>
  
  <p><strong>1.</strong> 00576<BR>
  <strong>2.</strong> 05768<BR>
  <strong>3.</strong> 57689<BR><BR></p>
  
  <p>Is it possible with any MySQL query? Any ideas?</p>