How to batch modify database contents in phpmyadmin

1. Enter phpmyadmin, click Search, and search for the content you want to replace. What to look for: Contact us. Select all tables. In phpmyadmin, there are many tables with "Contact Us" in them.

2. Click "Browse" behind one of the tables to enter, and find the field where the content to be replaced is "Contact Us" :name.

3. Enter the sql query interface and run the following MySQL statement:

UPDATE `pwn_base_plus` SET `name` = REPLACE(`name`,’联系我们’,’联系电话’);

Description: update replacement command Now pwn_base_plus is the table name and the field.

Note:

The name field type varchar in the example is a string type. If you want to replace the field th which is an int type, then REPLACE(`name`,'Contact us', 'Contact number'); does not need to be added.

For example: UPDATE `pwn_base_plus` SET `th` = REPLACE(`tg`,414,600);

Recommended related articles and tutorials : phpmyadmin tutorial

The above is the detailed content of How to batch modify database contents in phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!