Active Directory Products
Calls To Calendar
SMS To CSV
SMS To Gmail
Voicemail To Gmail
How Long For Me
<< Back To All Blogs
Search and Replace in MySQL
Sunday, October 9th, 2011
I often find myself looking for the proper syntax while attempting to do a search and replace in MySQL, and figured that I would help out by posting the syntax for someone else in the same situation:
UPDATE `schema`.`table` set column = replace(column, "find", "replace");
That syntax will find any values "find" within the schema and table, and replace them with "replace"
A pretty short post but hopefully helpful to some of you out there.
Replacin' Tom Out.
Awesome .NET 4: Named and Optional Parameters for Classes and Methods
Reading IPhone Text Messages using C# and SQLite
Creating High Quality Images with C# and GDI
Restoring Specific Documents from a MOSS 2007 Content Database Backup
Currently no comments.
Add A Comment
Email Address: (not public, used to send notifications on further comments)
Enter the text above, except for the 1st and last character: