Find "me too" (so-called) answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Finds the answers to questions that appear to be the "me too" style of answers that contribute absolutely nothiing to the question and should either be removed or converted to a comment by a mod.

Stack Overflow

Q&A for professional and enthusiast programmers

-- Find "me too" (so-called) answers
-- Finds the answers to questions that appear to be the "me too" style of answers that contribute absolutely nothiing to the question and should either be removed or converted to a comment by a mod.

SELECT Id as [Post Link],
       SUBSTRING(Body, CHARINDEX('me too', Body) - 15, 45) as [Occurrence]
FROM Posts WHERE
    PostTypeId = 2 AND
    (Body LIKE 'me too%' OR Body LIKE '% me too%') AND
    Body NOT LIKE '%affects me too%' AND
    Body NOT LIKE '%fixed it%' AND
    BODY NOT LIKE '%resolved%'

Enter Parameters

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