Find and Replace text in the entire table using a MySQL query

Find and Replace text in the entire table using a MySQL query

Short tips for today….

Database is a great tools to make a website looks dynamic.

But sometimes, we need to change the value quickly…

So, this is when we need to use phpmyadmin..

Use this code to update a value of a column quickly…

For a single table update

UPDATE `table_name`

SET `field_name` = replace(same_field_name, 'unwanted_text', 'wanted_text')

Leave a Reply