Web_PHP_DedeCMS_字段替换模块；

最新推荐文章于 2021-05-13 20:34:51 发布

cyb_23

最新推荐文章于 2021-05-13 20:34:51 发布

阅读量843

点赞数

分类专栏： MySQL Web_PHP

本文链接：https://blog.csdn.net/cyb_23/article/details/43638571

版权

Web_PHP 同时被 2 个专栏收录

77 篇文章 0 订阅

订阅专栏

MySQL

5 篇文章 0 订阅

订阅专栏

<span style="font-size:18px;">Web_PHP_DedeCMS_字段替换模块；
</span>

<span style="font-size:18px;">
</span>

<span style="font-size:18px;">->dede_archives
title
shorttitle
keywords
description
->dede_addonarticle
body

-->替换范例

SELECT id,title FROM dede_archives WHERE title LIKE '%%';
SELECT id,title,shorttitle FROM dede_archives WHERE shorttitle LIKE '%%';
SELECT id,title,keywords FROM dede_archives WHERE keywords LIKE '%%';
SELECT id,title,description FROM dede_archives WHERE description LIKE '%%';
SELECT id,title,body FROM dede_archives AS ar, dede_addonarticle AS ad WHERE ar.id = ad.aid AND body LIKE '%%';



UPDATE dede_archives SET title = REPLACE(title, "", "") WHERE title LIKE "%%";
UPDATE dede_archives SET shorttitle = REPLACE(shorttitle, "", "") WHERE shorttitle LIKE "%%";
UPDATE dede_archives SET keywords = REPLACE(keywords, "", "") WHERE keywords LIKE "%%";
UPDATE dede_archives SET description = REPLACE(description, "", "") WHERE description LIKE "%%";
UPDATE dede_addonarticle SET body = REPLACE(body, "", "") WHERE body LIKE "%%";
</span>