DEDECMS Bulk substitution of statements using SQL commands

1. Change the content in the article

Update dede_addonarticle set Body=replace (body, ' original character ', ' replaced character ')

2, replace the article title

Update dede_archives set Title=replace (title, ' original character ', ' replaced character ');

3. Replace article keywords

Update dede_archives set Keywords=replace (keywords, ' original character ', ' replaced character ');

4, replace the article description

Update dede_archives Set Description=replace (description, ' original character ', ' replaced character ');

5. Change the thumbnail directory

Update dede_archives Set Litpic=replace (Litpic, ' original character ', ' replaced character ')

6. Bulk replacement of software model content partial hyperlinks

Pdate Dede_addonsoft Set Introduce=replace (introduce, ' original characters ', ' substituted characters ');

7. Bulk replace author fields in the article model

Update dede_archives set Writer=replace (writer, ' original character ', ' replaced character ');

8. Bulk replace the source field in the article model

9. Bulk replacement software model demo address hyperlink

Update Dede_addonsoft Set Writer=replace (Officialurl, ' original character ', ' replaced character ');

10. Batch review articles

Update dede_archives Set arcrank=0

Note: arcrank=0 only dynamic

DEDECMS Bulk substitution of statements using SQL commands