When trashing a post, also trash related comments so here is what i want， what‘s’ the sql Command
I want to move some post to trash according their ID， what is the sql command，I can restore these post and their comments using sql command
Add a comment
|
2 Answers
I would discourage using raw SQL for moving a post to a trash or back, especially since there's a build in function for it:
wp_trash_post( $post_id );
More about the wp_trash_post() function.
The opposite is:
wp_untrash_post( $post_id );
wp_untrash_post() also untrashes trashed comments.
In WP there are functions for many things - for instance you can trash/untrash only comments, leaving the post alone - in that case use: wp_untrash_post_comments() and wp_trash_post_comments().
-
when i run wp_trash_post($87); it show wrong message in sql command “mysql> wp_trash_post($87); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'wp_trash_post($87)' at line 1” Jun 26, 2017 at 15:30
-
This is a command that you need to run from within the wordpress files having administrator rights, I didn't know you want to run this scripts in the mysql terminal and that is a different story.– PicardJun 26, 2017 at 17:29
-
-
But why would you like to do it in the raw SQL? If you analyze the WP source there are many conditions and dependencies to take care of when un/trashing comments/posts in some cases this could be more than a one simple SQL command. If you'd like to do it from the command line but not exactly from MySQL you can check the WP CLI system - command line interface for WP - for instance here is how to untrash comments– PicardJul 11, 2017 at 6:51
Sql Command for trashed a post with comments for that post:
$post_status = 'trash';
$post_array = '1, 2, 3'; //post_ids comma separated
$wpdb->query($wpdb->prepare(
"UPDATE
`wp_posts`,
`wp_comments`
SET
wp_posts.post_status= %s,
wp_comments.comment_approved= %s
WHERE
wp_posts.ID = wp_comments.comment_post_ID AND
wp_posts.ID IN ( $post_array )",
$post_status,
$post_status
));
