Helpmonks Logo

How to search & replace in MySQL

How to search & replace in MySQL

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

[code]update table
set
column = replace(column,’thistext’,’thattext’)
[/code]

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

Nitai

Nitai

Founder & CEO of Helpmonks. Serial Entrepreneur. Getting things done.