thread mass delete

[manuelsechi]

I just want to delete all the thread in some forum, what about something like this?

PHP Code:

delete from post where threadid in (select id from thread where forumid = 1) 


and then

PHP Code:

delete from thread where forumid = 1 


or
I could simply delete threads and then purge orphan messages? I just want to avoid producing dirty data...

thank you