SQL To Change Scheduled Posts To Published

If you ever need to “bulk” change posts (or pages) from Scheduled to Published, you could of course try doing that by carrying out the following instructions.

This is a standard solution for this:

  1. Selecting Desired Posts/Pages.
  2. Click “Bulk Actions” Drop-down.
  3. Click “Edit.”
  4. Click “Apply” button.
  5. Change the “Status” from Scheduled to Published.
  6. Click “Update.”

However, I’ve found that sometimes that does not work, and posts/pages get “stuck” as Scheduled.

If you need to forcefully publish a page, you can do so by going into the install’s phpMyAdmin and…

Run an SQL statement instead:

  1. Click the proper database structure in the left sidebar.
  2. Go to the “SQL” Tab.
  3. Paste in the following code (below).
  4. Click “Go.”
UPDATE wp_posts SET post_status = 'publish' WHERE post_status = 'future';

Note: That will update ALL posts, pages, etc. to be published, if they previously were set to Scheduled.

Need help?

Tell us about your project!

This field is for validation purposes and should be left unchanged.

Related articles