I am launching a blog where a community can post time-related community links (sports results, etc.). After a certain time, these messages are no longer useful, so I want to delete them in batch mode using the MySQL query, but I do not know how to do this. I suppose getting rid of these messages is more than just deleting wp_posts from the table, right? There are no other tables in the workplace, right?
I tried a couple of plugins with automatic or batch removal, but they do not work for half the time.
Please, could you provide a MySQL query to delete messages and parts of them older than X days from all relevant tables?
Thanks in advance.
- Nick
source
share