A collection of 3 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%'

You've successfully subscribed to Base 64!
Could not sign up! Invalid sign up link.