Home
Blog
Software
Contact
Mailing List
IPhone Products
SMS To Gmail
Voicemail To Gmail
Calls To Calendar
Other Products
TiffWizard
Sites
SaveMySerials
How Long For Me
DocuTerminal
Subsonos
 Blog
 Twitter
|
<< 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.
Tags
Howto
MySQL
Related Blogs
Determining if MOSS is Standard or Enterprise
Disabling Outlook restricted extensions
Querying LDAP from Excel directly with VBScript
Resolving Odd 5 Minute Timeout in HttpWebRequest.
Resolving ASP.NET Web.Config Inheritance
Comments
Currently no comments.
Add A Comment
Name:
URL:
Email Address: (not public, used to send notifications on further comments)
Comments:
Enter the text above, except for the 1st and last character:
|