Find comments containing a particular phrase on another user's answers


Please login or register to vote for this query.

(click on this box to dismiss)

Returns all comments (linked) containing a particular phrase on answers by a particular user. Comments by the answerer are not included.

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

-- UserId: User ID whose answers to check for comments "The comments for this users answers are checked"
-- CommentContains: Comment should contain

SELECT C.Id AS [Comment Link]
FROM Comments C
    JOIN Posts P ON C.PostId = P.Id
WHERE P.PostTypeId = 2
    AND P.OwnerUserId = ##UserId:int##
    AND UPPER(C.Text) LIKE UPPER('%##CommentContains##%')
    AND C.UserId <> ##UserId##

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results