• typecho_metas下面存有分类名字,首先通过这张表选出mid
  • 然后从typecho_relationships中选出属于该分类的全部cid,即文章id
  • 更新typecho_contents中的status即可改变文章公开度
USE typecho;
UPDATE typecho_contents SET STATUS = "hidden"
WHERE cid IN (
SELECT cid
FROM typecho_relationships
WHERE MID = (
SELECT MID
FROM typecho_metas
WHERE NAME = "分类名字"));

标签: none

添加新评论