易优cms怎么批量替换指定栏目下的标题的文字-- 替换指定栏目ID（如5）及所有子栏目下的文章标题UPDATE ey_archivesSET title = ｒｅｐｌａｃｅ(title, '旧文字', '新文字')WHERE typeid IN ( SELECT id FROM ey_arctype WHERE FIND_IN_SET(5, parentstr) OR id = 5);2. 仅替换当前栏目（不含子栏目）sql-- 仅替换栏目ID=5，不含子栏目UPDATE ey_archivesSET title = ｒｅｐｌａｃｅ(title, '旧文字', '新文字')WHERE typeid = 5;易优cms批量替换指定栏目下的点击量UPDATE ey_archivesSET click = ｒｅｐｌａｃｅ(click, '1', '0')WHERE typeid = 521;多个UPDATE ey_archivesSET click = ｒｅｐｌａｃｅ( ｒｅｐｌａｃｅ( ｒｅｐｌａｃｅ( ｒｅｐｌａｃｅ( ｒｅｐｌａｃｅ( ｒｅｐｌａｃｅ( ｒｅｐｌａｃｅ( ｒｅｐｌａｃｅ( ｒｅｐｌａｃｅ(click, '1', '0'), '2', '0'), '3', '0'), '4', '0'), '5', '0'), '6', '0'), '7', '0'), '8', '0'), '9', '0') WHERE typeid = 521;易优cms怎么批量在标题前插入文字sql-- 给所有文章标题前加【前缀文字】UPDATE ey_archives SET title = ｃｏｎｃａｔ('【前缀文字】', title);-- 按条件添加（如仅给栏目ID=1的文章加）UPDATE ey_archives SET title = ｃｏｎｃａｔ('【前缀文字】', title) WHERE typeid = 1;-- 按状态添加（仅已审核文章）UPDATE ey_archives SET title = ｃｏｎｃａｔ('【前缀文字】', title) WHERE arcrank = 1;UPDATE ey_archives aLEFT JOIN ey_article_content b ON a.aid = b.aidSET a.title = TRIM( SUBSTRING( ｒｅｐｌａｃｅ(ｒｅｐｌａｃｅ(b.content, '', ''), '', ''), 1, LEAST( IF(LOCATE('。

', ｒｅｐｌａｃｅ(ｒｅｐｌａｃｅ(b.content, '', ''), '', '')) > 0, LOCATE('。

', ｒｅｐｌａｃｅ(ｒｅｐｌａｃｅ(b.content, '', ''), '', '')) + 1, 999), IF(LOCATE('！', ｒｅｐｌａｃｅ(ｒｅｐｌａｃｅ(b.content, '', ''), '', '')) > 0, LOCATE('！', ｒｅｐｌａｃｅ(ｒｅｐｌａｃｅ(b.content, '', ''), '', '')) + 1, 999), IF(LOCATE('？', ｒｅｐｌａｃｅ(ｒｅｐｌａｃｅ(b.content, '', ''), '', '')) > 0, LOCATE('？', ｒｅｐｌａｃｅ(ｒｅｐｌａｃｅ(b.content, '', ''), '', '')) + 1, 999) ) ) )WHERE a.channel = 1 AND a.typeid = 1 AND b.content != '';