Bulk date change for wordpress posts
category: Snippets
There was a time when a client contacted me and asked me if it possible to change the dates of his posts. Before half a year i created for him a registry for product specifications, using (what else) wordpress. So after about six months he ended up with about 200 posts/products. So it was a nightmare to break my working schedule and start changing his posts one by one. Thankfully his employees were adding these posts in specific dates so it was easy for me to use the following SQL code in phpMyAdmin.
The first date under post_date is the current and the other is the new date.
UPDATE wp_posts SET post_date = REPLACE ( post_date, '2008-01-30', '2009-01-30')
Leave a Reply
7 New things coming with Wordpress 3.0
Default Theme
Let’s begin with something that waited to be updated a lot of time. The default theme. Wave goodbye to Kubrick and say hello to 2010. Rumors say that… read more
PollDaddy redesigned
PollDaddy, the polling service that integrates perfectly with Wordpress, and the one that bought by Automatic on October 15th, 2008, has finally redesigned.
Rich re… read more
Wordpress 2.9.2 released
Today, and after an alert about thrashed posts being viewable from logged in users (not post authors), we have a new security update. Webmasters of sites that have untr… read more
Menu Management in Wordpress 3.0
Today, we’ve read from the WPtavern and the wp-ui mailing list, that the next major update of wordpress, will incorporate one killer feature: Menu Management a… read more

Share on Facebook
Share on twitter
Subscribe to our RSS
