Bulk delete in MySQL

Hi,

I need to bulk delete old data from MySQL and need help on query command on date.

Thanks for any help.

 

What exactly you want deleted in your database ? post ? comment ? data in table ? row ?

 

All data related to post with specified range of date
eg: 2008/12/01 - 2009/04/25 to be deleted

 

Sorry , but what do you mean by " data related " ? . It's mean a post with name like " post " + date from 2008/12/01 - 2009/04/25 , will be deleted .

Or just want all of post have date from 2008/12/01 - 2009/04/25 will be deleted ?

Show me !

 

MySQL Command :

1. If you want deleted all post have date from 2008/12/11 - 2008/12/13 you can using :

In this , table is table name .

2. If you want to deleted a post have content " post " in any column and date from 2008/12/11 and 2008/12/13 , you can using this :

Regards.

 

Yes, I need the 1st query which delete range of date but got any error as :

 

Sorry missing date table

Working great, thanks for your great help.

 

No problem. I would like to help people which are member of DP . You're welcome

 

Btw, before you randomly execute anything another user here says on this forum, it's always best to change the DELETE statement to a SELECT * and confirm that it is indeed the data you want to delete. There's no turning back from these kinds of statements otherwise

 

With SELECT * statement I got a resulted as :-

even the posts within this date is in database.