<div>
Change the field definition from int to char(5), and then a quick one-time change (in php would be trivial to do) to add the leading zero where needed.
</div>


Change the field definition from int to char(5), and then a quick one-time change (in php would be trivial to do) to add the leading zero where needed.

<div>
<div class="content wysiwyg-content">
Hello, I imported a database and concatenated it. &nbsp;It has over 150,000 records.<br />
<br />
Every record has a zip code<br />
<br />
Every zip code w/ a leading zero has deleted the zero and I just realized it. &nbsp;<br />
<br />
Is there a way to fix this w/ our importing the database again?<br />
<br />
Example:<br />
<br />
07030 is in the database as 7030<br />
<br />
I could do a php script to check strlen and then if not 5 add leading zeros until it is 5, but I would like it to be right in the database.<br />
<br />
Can you help? &nbsp;Thanks.
</div>
</div>


Hello, I imported a database and concatenated it.  It has over 150,000 records.

Every record has a zip code

Every zip code w/ a leading zero has deleted the zero and I just realized it.  

Is there a way to fix this w/ our importing the database again?

Example:

07030 is in the database as 7030

I could do a php script to check strlen and then if not 5 add leading zeros until it is 5, but I would like it to be right in the database.

Can you help?  Thanks.

Leading Zeros Zip Code MySQL

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Web applications are systems that run in browsers that perform functions normally associated with other client-based programs. One of the most commonly used web applications is email; instead of downloading individual emails to a local machine, the data is shown through a website. Other examples of web applications are collaborative systems like a wiki or an online game.