how to edit dynamically mysql data rows?
<p>Is it possible to add an extra character into existing data in my database through SQL? I.e., I have these rows and I need to add extra 0 on <code>zip_codes</code>.</p>

<pre><code>id    | state_abbr | zip_code
16993 | MA         |   1001
16994 | MA         |   1002
16995 | MA         |   1003
</code></pre>

<p>I want to change it to:</p>

<pre><code>id    | state_abbr | zip_code
16993 | MA         |   01001
16994 | MA         |   01002
16995 | MA         |   01003
</code></pre>