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.
