Advanced Search

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