How to implement batch replacement in dedecms

Dedecms method to implement batch replacement: 1. Open "Dreamweaver cms backend->Core->Batch Maintenance->Database content replacement" in sequence, and then select the database tables that need to be replaced for batch replacement; 2. Use the SQL command "update dede_archives set title=replace(title,'xx','yy');" to achieve batch replacement and modification of article titles or text keywords.

The operating environment of this tutorial: Windows 10 system, DedeCMS version 5.7, Dell G3 computer.

dedecms How to implement batch replacement?

Methods for bulk replacement of article titles and text content keywords

I believe that for many webmasters of Dreamweaver dedecms, they should often encounter collection When writing articles or copying other people's articles, you need to batch modify the article title, keywords, text, author, source, date and other related information. Because it is common for article titles or article content to change. If you change it manually, it will definitely make people vomit blood. So is there any way to replace related content in batches? Below, Baiqi SEO will share with you two methods.

Two detailed methods for replacing article titles or article body content in batches with Dedecms:

The first method: Changing the background operation of Dedecms site (strongly recommended)

Steps:

1. Dreamweaver cms backend - core - batch maintenance - database content replacement

2. If you need to replace article titles in batches, select the dede_archives database table and select the field title field, select Normal Replacement. For example: the content to be replaced: Dreamweaver cms batch replace article title and content method set, replace it with: dedecms batch replace article title and content method, enter the security confirmation code, start replacing data, and finally update to generate the following OK.

3. If you need to replace a certain keyword in the article summary, for example, if you want to replace "dedecms" with "dreamweavercms", you can select the dede_archives data table, select the description field, and fill in the words that need to be replaced. Content: dedecms, replace with: dreamweaver cms, enter the security confirmation code, start replacing data, and finally update to generate the following and it will be ok.

4. If you need to replace some keywords in the article body, for example, if you want to replace "DreamWeaver SEO Blog" with "DreamWeaver SEO", you can select the dede_addonarticle data table, select the body field, and fill in the fields that need to be replaced. Content: DreamWeaver SEO blog, replace it with: Dreamweaver SEO, enter the security confirmation code, start replacing data, and finally update and generate it.

This method operates directly in the background of the DreamWeaver cms site, which is more intuitive and easier to operate.

Second method: Use SQL commands to batch replace and modify article titles or text keywords [This method is recommended for friends who are more familiar with mysql database operations]

Steps: Enter the database of the website In the background, select the database that needs to be modified

1. The title of the relevant article needs to be replaced

mysql command: update dede_archives set title=replace(title,'original keyword','replaced key Word');

For example: I want to replace "Dreamweaver cms" in "Dreamweaver cms batch replacement article title and content method collection" with "dedecms", and then I can write the mysql modification command: update dede_archives set title=replace(title,'Dreamweaver cms','dedecsm');

2. Need to modify a certain keyword of the article summary

mysql modification command: update dede_archives set description= replace(description,'original keyword','replaced keyword');

3. Need to replace a certain keyword in the article text

mysql modification command: update dede_addonarticle set body=replace(body,'original keyword','replaced keyword');

4. Change the thumbnail directory

mysql modification command: update dede_archives set litpic= replace(litpic,'original thumbnail','replaced thumbnail').

It is relatively convenient for Dedecms to replace article titles and content in batches. If you encounter this problem, you can try both of the above methods.

Recommended learning: dedecms tutorial

###

The above is the detailed content of How to implement batch replacement in dedecms. For more information, please follow other related articles on the PHP Chinese website!