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
Resolving Odd 5 Minute Timeout in HttpWebRequest.
Resolving Avaya Denial Event 2378
Fedora Core 20 and Apache Virtual Host on mounted share
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: