WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How would I bulk change posting date? I want to change about 20 post publish dates at a time in one click

share|improve this question

Post date/time can't be changed via the Quick-Edit bulk editor. You might edit the SQL directly, if you're comfortable running a query in PHPMyAdmin. Or, you could search for a Plugin?

share|improve this answer

I just had a similar issue. I used this:

UPDATE `wp_posts` 
SET post_date = "2008-02-13 23:50:30"
WHERE post_status = "publish"
AND post_date >=DATE_SUB(CURDATE(),Interval 5 day)

It is updating the wp_posts table and changing anything published in the last 5 days to the date of 2008-02-13.

share|improve this answer
You you mind making your answer WP compatible? $wpdb->query, $wpdb->posts, etc.? – kaiser Feb 14 '14 at 2:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.