How Can I Efficiently Find and Replace Text Across My MySQL Database?

Find and Replace Text in an Entire MySQL Table Using SQL

Manually finding and replacing text in a MySQL database can be a time-consuming task. Fortunately, there's a more efficient way: using a MySQL query.

Example

Let's say you need to replace all instances of "domain.example" with "www.domain.example" in a table called "website."

Query

For a single table, you can use the following query:

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

In this case, the query would be:

UPDATE `website`
SET `url` = replace(`url`, 'domain.example', 'www.domain.example')

Multiple Tables

If you need to replace text in multiple tables, you can use a script to dump all the tables and then use a find/replace tool to update the text. Then, re-upload the updated dump.

The above is the detailed content of How Can I Efficiently Find and Replace Text Across My MySQL Database?. For more information, please follow other related articles on the PHP Chinese website!