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

Question

Normally, I manually find to replace text in a MySQL database using PHPMyAdmin. I am very much exhausted of it now, So how can I execute a query to find and replace a text with the new text in the whole table in PHPMyAdmin?

Example: Find the keyword domain.com, and replace it with www.domain.com.

Answer 1

For a single table update:

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

For Multiple tables-

If you need to edit from all the tables, the simple way is to take the dump and then find/replace and upload it back.

Willing to Learn SQL? Join the SQL Certification course by Intellipaat.