Add Leading zero to field (ZipCodes)


/ Published in: MySQL
Save to your folder(s)



Copy this code and paste it in your HTML
  1. UPDATE tbl_Name SET ZipCodes = concat('0',ZipCodes) WHERE length(ZipCodes) = 4

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.