How to search & replace in MySQL

Share this post:

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.

Over 10 years in business.

Self-funded. No investors. No bullshit.

More than 3,000 customers worldwide.

Helpmonks - no bullshit customer engagement service

Growth starts with action

Empower your team and delight your customers.

Helpmonks - email management for small businesses