1

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.

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##

fork query

edited jun 15

created jun 15 w3dk