WordPress

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.

See our featured website design work

Check out some of the beautiful websites we’ve built for over 2,000 clients.

We offer WordPress support & maintenance

Shake the stress of ongoing maintenance with plans supported by our team of WordPress experts.

Related articles