Sql query (Update a column value, replacing part of a string) UPDATE your_table_name SET `column_name` = REPLACE(`column_name`, 'CurrentString', 'To_replace_String');