wordpress数据库操作 批量删除/替换 媒体库/特色图/文章/发布状态

批量删除分类下的文章

delete
from
wp_posts 
using 
wp_posts,
wp_term_relationships,
wp_term_taxonomy 
where 
wp_posts.id=wp_term_relationships.object_id 
and 
wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id 
and 
wp_term_relationships.term_taxonomy_id = 1

delete
from
wp_posts
using
wp_posts,
wp_term_relationships,
wp_term_taxonomy
where
wp_posts.id=wp_term_relationships.object_id
and
wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
and
wp_term_relationships.term_taxonomy_id = 1

批量替换内容和网址

UPDATE wp_posts SET post_content = REPLACE(post_content, '原内容' , '替换为的内容');

批量清空特色图片

global $wpdb;
$wpdb->query( "
DELETE FROM $wpdb->postmeta 
WHERE meta_key = '_thumbnail_id'
" );

批量修改文章发布状态
WordPress文章状态分为：草稿’draft’，已发布’publish’，待审核’pending’

UPDATE `wp_posts` SET `post_status` ='draft' WHERE (`post_status`='publish');

清空媒体库数据库

DELETE from wp_posts where post_type = 'attachment'

清空媒体数据库后，怎么删除媒体文件和文章之间的联系呢？使用下面的命令。

DELETE FROM `wp_postmeta` WHERE meta_key IN ('_wp_attached_file', '_wp_attachment_backup_sizes', '_wp_attachment_metadata', '_thumbnail_id')