There are basically 2 ways suggested method: 1st, save/copy the database table and use text editor's "search and replace" function and fill table with new content; 2'nd , use MySQL REPLACE function: UPDATE table_name SET column_name = REPLACE(column_name,"original_text","replace_text")