What is the best way to delete thousands of spam comments?

Topics: Administration
Oct 20, 2012 at 2:00 AM

Any tip will be greatly appreciated?

Hong

Nov 5, 2012 at 3:06 AM
Edited Nov 5, 2012 at 3:07 AM

DELETE
FROM [OrchardHong].[dbo].[Orchard_Comments_CommentPartRecord]
WHERE SiteName IS NOT  NULL

 

Marked as answer by zipswich on 10/23/2013 at 11:24 AM