UPDATE `your_table` SET your_column_1=REPLACE (your_column_1, 'your_before_words', 'your_after_word');