Return to Snippet

Revision: 48819
at July 10, 2011 14:34 by kidmizere


Initial Code
UPDATE tbl_Name SET ZipCodes = concat('0',ZipCodes) WHERE length(ZipCodes) = 4

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

Initial Description

                                

Initial Title
Add Leading zero to field (ZipCodes)

Initial Tags

                                

Initial Language
MySQL