Revision: 48819
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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