If you want to replace parts of a string that is embedded in an SQL Database you might want to try this:


UPDATE `mt_entry` SET `entry_text` = REPLACE

This will go to the table "mt_entry"; and look into "entry_text";. If "entry_text"; contains the words "/assets/"; it will replace those words with a simple "/";

Comments