Table：mt-entry
subject: entry_text
search：abc
replace：def
update mt_entry set entry_text=replace(entry_text,'abc','def')
Davy's Blog
Nothing is impossible for a willing heart.
Using mysql to replace word in database
Posted on November 9, 2009 greenhawk
Share this Post:
Leave a Reply:
Categories
Books
CSS styles
ExtJS
Google
Moon
Mysql
PHP Learn
SEO
WordPress
XML
Zend FrameworkArchives
- January 2012
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
Recent Posts
Great Daily Deals
- $39 for a Carpet Cleaning including Three Rooms from R&R Carpet Cleaning ($150 value)
- $29 for a Furnace Safety and Tune-Up Service from Air Dynamic Solutions Heating & Cooling ($140 Value)
- $39 for a Bluetooth Headset from iNeeds.ca ($99 Value)
- $75 for an At-Home Teeth-Whitening Kit and Maintenance Whitening Pen with Tax and Shipping Included from Whitening Lightning ($478 Value)
- $20 for $40 Worth of Pizza, Pasta, and Drinks at Amaro Pizza