Search my own comments...

7

Please login or register to vote for this query.

(click on this box to dismiss)

This query returns the linked list of your comments (along with score and post where you've posted them) partially matching the entered comment text. Search is not case sensitive. The UserID parameter is your user ID (by default prefilled with your user ID) and the CommentText is the text which you want to search for.

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @CommentText nvarchar(600) = ##CommentText:string##

SELECT
    Id AS [Comment ID],
    PostId AS [Post ID],
    Score AS [Comment Score],
    Text AS [Comment Text],
    CreationDate AS [Creation Date]
FROM
    Comments
WHERE
    UserId = 960757 AND
    Text LIKE '%' + @CommentText + '%'
ORDER BY
    CreationDate
ASC

Enter Parameters

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