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
Creating a PDF with C# and iTextSharp
Writing console output from a Windows form in C#
Fixing MOSS Search Crawler issue for "The specified address was excluded..."
Setting up a real VPN with your every day consumer router and DD-WRT
Reading IPhone Text Messages using C# and SQLite
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:
|