Replace text in MySQL query

If you'd like to replace the text in a MySQL column you can run the following query:

UPDATE tableName SET columnName = REPLACE(columnName, 'old text to replace', 'new text to replace with') WHERE columnName LIKE '%search_term%';

LIKE '%search_term%' is used to find rows with text matching the search term in a particular column.