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.
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.
You must be logged in to post a comment.
Follow @thenitai on Twitter
No comments yet.