X

Things To Keep In Mind Before Publishing Post In WordPress/ Blogger

Things To Keep In Mind Before Publishing Post In WordPress/ Blogger – If you are little geeky,  you might also want to know a method, which enables you to achieve the same as above by running the SQL query from your PHPMyAdmin. Login into your phpMyAdmin and click on your site’s database and then select the wp_posts  and click on SQL.

Things To Keep In Mind Before Publishing Post In WordPress/ Blogger

Enter the following query:-

UPDATE wp_posts SET post_status = 'publish' WHERE post_status = 'draft' and post_type = 'post';

And click on GO. That’s it and you are done.

You can check for the number of rows affected by your query.

The explanation for the above query-

Here In the above query, I am asking my database to update the post of the status to “Publish” for those whose current status is “Draft” and the post type is ‘Post‘.

If you want to publish ‘Pages‘ instead of ‘Posts‘ then replace the post with the page in post_type as below-

UPDATE wp_posts SET post_status = ‘publish’ WHERE post_status = ‘draft’ and post_type = ‘page’;

Values that you can pass in above query for post_status are:

  • Publish
  • Draft
  • Pending
  • Private
  • Trash

Values for post_type that can be passed in the above query are:

  • Page
  • Post
  • Revision
  • Attachment
  • And any custom type if you are using.

Any queries regarding Things To Keep In Mind Before Publishing Post In WordPress/ Blogger are also welcomed in the comment box below. If you know any WordPress tips, then don’t forget to share with us. Because we love WordPress and We would love to hear from our Blog readers as well. Read more related to Things To Keep In Mind Before Publishing Post In WordPress/ Blogger using below links of ALLINDIAROUNDUP website –

Things To Keep In Mind Before Publishing Post In WordPress/ Blogger

Rate This