> ## Content Index
> Fetch the complete content index at: https://helpmonks.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to search & replace in MySQL
- URL: https://helpmonks.com/blog/how-to-search-replace-in-mysql/
- Published: 2011-11-29T00:00:00.000Z
- Updated: 2026-04-04T01:57:55.000Z
- Description: Thinking of a way to quickly search & replace data in a MySQL column got me to this solution: With this method I was quickly able to change millions of recor
- Author: Nitai
- Tags: email marketing

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.