PHP & MySQL delete all comments related to an article question.

Question

Lets say I have 20 comments that are related to article_id 76 will I have to count all the article ids that have an article_id 76 and then run a foreach loop for all the comments related to article 76 or can I delete all the comments related to that article using a query?

SELECT article_id FROM articles_comments WHERE article_id = 76

Answer 1

DELETE FROM articles_comments WHERE article_id = 76;

Answer 2

DELETE FROM articles_comments WHERE article_id = 76

Answer 3

Just one operation:

 delete from article_comments where article_id = 76

Answer 4

No need for any looping.

This one query will delete all the comments related to article_id 76

DELETE FROM articles_comments 
WHERE article_id = 76;