advanced code snippet search

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

Expand | Embed | Plain Text 
  1. UPDATE tbl_Name SET ZipCodes = CONCAT('0',ZipCodes) WHERE LENGTH(ZipCodes) = 4

Report this snippet  

You need to login to post a comment.