Posted By

kidmizere on 07/10/11


Tagged

zero leading zipcodes


Versions (?)

Add Leading zero to field (ZipCodes)


 / Published in: MySQL
 

URL: http://lists.mysql.com/mysql/199332

  1. UPDATE tbl_Name SET ZipCodes = CONCAT('0',ZipCodes) WHERE LENGTH(ZipCodes) = 4

Report this snippet  

You need to login to post a comment.