Short comments to delete

0

Please login or register to vote for this query.

(click on this box to dismiss)

Most of these can be flagged as Chatty

The Great Outdoors

Q&A for people who love outdoor activities, excursions, and outdoorsmanship

SELECT 
'http://math.stackexchange.com/questions/' + CAST(PostId AS VARCHAR),
  Text,
  Score,
  Comments.CreationDate,
  Users.DisplayName,
  Users.Reputation
FROM 
  Comments inner join 
  Users on Comments.UserId = Users.Id
WHERE 
  LEN(Text) < 30
  AND
    (
    Text LIKE '%thank%' OR
    Text LIKE '%not%answer%' OR 
    Text LIKE '%stupid%' OR
    Text LIKE '%got it%' OR
    Text LIKE '%welcome%' OR
    Text LIKE '%works%' OR
    Text LIKE '%noob%' OR
    Text LIKE '%newbie%' OR
    Text LIKE '%perfect%' OR
    Text LIKE '%bad answer%' OR
    Text LIKE '%fixed%' OR
    Text LIKE '%bro%'
    )
    
ORDER BY CreationDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results