My blog installation has a large number of soft deleted blog entries. I want to hard delete these. What is the best way to do so?
Is there a query I can use?
Would something like this work:
Is there a query I can use?
Would something like this work:
Code:
truncate blog_textparsed; delete from blog_text where state = 'deleted' delete from blog where state = 'deleted'