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

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.

Blender Meta

Q&A about the site for people who use Blender to create 3D graphics, animations, or games

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

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