wordpress 数据库设置某分类所有文章密码保护

UPDATE wp_posts, wp_term_relationships, wp_term_taxonomy
SET wp_posts.post_password = ‘123456’
WHERE
wp_posts.ID = wp_term_relationships.object_id
AND
wp_term_taxonomy.taxonomy = ‘category’
AND
wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
AND
wp_posts.post_status = ‘publish’
AND
wp_posts.post_type = ‘post’
AND
wp_term_taxonomy.term_id = ‘5’;

//123456为新设置的密码，id=5是文章分类的id