How to change publish date and status for future posts in WP?

Hello,

Can somebody help me out with a mysql script/statement to change the publish status and date for future posts?

I have many future posts that i want to publish by mass. All futurre posts have all kind of dates in the future. So all posts later than today need to be published at once.

Can somebody help me out with a SQL script/statement for this?

Thanks in advance.

 

i think you can edit the date of the article.just click quick edit under title post.
hope this will help you!

 

This will give you posts from future. Then you can edit the post date as per your choice, for these rows..

 

@rahulsonar

Oke... but how to set a specific date for all these records... including the status Published.

Example... set all future posts on publish date 31-08-2010 and status Published. You need an update statement.... i don't want to update all data manually because than i can use the wordpress admin panel.

Please help me out.

Thanks in advance

 

You need to put there instead [...] what date you want.