Web_PHP_DedeCMS_字段替换模块；

来源：互联网发布：程序员发展前景编辑：程序博客网时间：2024/05/21 09:49

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

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

<span style="font-size:18px;">->dede_archivestitleshorttitlekeywordsdescription->dede_addonarticlebody-->替换范例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>

0 0