Advanced Search

Return to Snippet

Revision: 43568
at March 26, 2011 07:33 by kidmizere
Initial Code 
update tbl_NMR_users set `tbl_NMR_users_FirstName` = CONCAT(`tbl_NMR_users_FirstName`,' TESTING') Where `tbl_NMR_users_RegNumber` = '156330';
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Notice the space in the appended portion, otherwise you just tack right on with no separation.
If your original value is null you can use this:
CONCAT(IFNULL(email_data, ''),' $email_data')
This will add it on to a null value as the first value in the entry

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Append Data to Field in MySql

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL