The method of batch modifying Database content in phpmyadmin

This article will explain in detail the method of batch modification of database content in phpmyadmin. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

1. Enter phpmyadmin, click search, and search for the content you want to replace. Contact us when you are looking for something such as: contact us. Select all tables. In phpmyadmin, there are many tables that have "contact us".

2. Click "Browse" at the back of one of the tables to enter, and find the field of "contact us" that needs to be replaced: name.

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

UPDATE `pwn_base_ plus` SET `name` = REPLACE (`name`, 'contact us', 'contact phone')

Description: update replacement life today pwn_base_plus is a table name is a field.

Note:

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

For example: UPDATE `pwn_base_ plus` SET `th` = REPLACE (`tg`, 414600)

This is the end of the method of batch modification of database content in phpmyadmin. I hope the above content can be of some help to you and learn more knowledge. If you think the article is good, you can share it for more people to see.