text

A collection of 4 posts

Replace text in MySQL query

mysql replace text 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%'