Need a query to remove attachments

[ericgtr]

Anyone have a query they can throw my way that will remove all attachments in a specific forum?

[Marco van Herwaarden]

You will have to join with the post and the thread table to find out in which forum an attachment is posted.

[Andreas]

You will need at least mySQL 4.0.2 for this type of query:

[sql]
DELETE FROM attachment USING attachment, post, thread WHERE attachment.postid = post.postid AND thread.threadid = post.threadid AND thread.forumid = X
[/sql]

[ericgtr]

Thanks, seemed to work fine