Just use the fabulous command REPLACE provided by mysql. The syntax goes like this:
update database_table set table_column = replace (table_column, "oldstring", "newstring");
For instance, to replace all occurrences of “modules” inside the linuxformat.gr drupal db with “sites/all/modules” I typed in:
update linuxformat_system set filename = replace (filename, "modules", "sites/all/modules");
xABBAAA
"... I like C++ Qt, and Linux Ubuntu... "
Dimitris Kalamaras
"Thanks for the heads up. A note has been added in the beginning ..."
Gordon McIntosh
"startssl has been closed since 1st Jan 18 "
muhtadin
"Hello, i have final project (thesis in undergraduate program) using SNA as basic ..."
Rene Dorleijn
"This certainly solves the problem! Thanks Dimitris. All the menu texts can be read ..."
LinuxPowered by WordPress & Theme by Anders Norén
Evaggelos Balaskas
Excellent post and extremely useful !
dimitris
Thanks m8t 🙂
asteia
Very useful, thx a lot