Advanced Search

Return to Snippet

Revision: 52576
at October 26, 2011 23:50 by carouselcreative
Initial Code 
UPDATE `table` SET fieldname = replace( fieldname, "fromthis", "tothis" )
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Used to update a database field using search replace.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Update database fields with search replace word

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
search, replace, update

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL