Replacing Strings in SQL
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 "/";