MySQL – Find and Replace text in a table

MySQL Best Practices

Using ‘replace’ you can find and replace text of a column in a table.

Example of Replace text:

UPDATE `tbl` SET `field_name` = replace(field_name, 'old_text', 'new_text');

For any types of queries, you can contact us on

You may like:  MySQL stored procedure parameters and variables

Leave a Reply

Your email address will not be published. Required fields are marked *