Active Directory Products
Calls To Calendar
SMS To CSV
SMS To Gmail
Voicemail To Gmail
How Long For Me
My Music To 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.
Setting up a real VPN with your every day consumer router and DD-WRT
Resolving ASP.NET Web.Config Inheritance
First Version of SharePoint Validator now available on CodePlex
LastPass Extension not enabled after installation in Chrome
Validate a Windows Username and Password against Active Directory
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: