How to Efficiently Find and Replace Text Across MySQL Tables?

Finding and Replacing Text in an Entire Table with MySQL

Replacing specific text in a database can be a tedious task if done manually. MySQL provides a convenient solution to automate this process through SQL queries. Here's how you can find and replace text in an entire table:

Single Table Update

For a single table update, use the following syntax:

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

Replace the table_name, field_name, unwanted_text, and wanted_text with the actual table name, field name, old text, and new text, respectively.

Multiple Table Update

If you wish to replace text across multiple tables, it's recommended to export the database as a dump, manually find and replace the text in the dump file, and then re-import the dump.

Example

To replace the domain.example keyword with www.domain.example in the website field of the users table, execute the following query:

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

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