This is the default text

How to search & replace in MySQL

Thinking of a way to quickly search & replace data in a MySQL column got me to this solution:

update table
set
column = replace(column,'thistext','thattext')

With this method I was quickly able to change millions of records today. Quick and easy.

, ,

No comments yet.

Leave a Reply