How to select particular month post from table and update the post status using MySQL?
Use WP CLI! First grab the posts you want, we’ll use the wp post list command, and we need to run the command in our WordPress directory on the server. Here I’m grabbing all posts in October 2014 on my blog: wp post list –year=2014 –monthnum=10 This gives me ( oh noes my secret draft … Read more