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.

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

DECLARE @MyUserID INT = ##UserID:int##
DECLARE @CommentText nvarchar(600) = ##CommentText:string##

SELECT @CommentText = UPPER(@CommentText)
SELECT
    PostId AS [Post Link],
    Score AS [Score],
    Id AS [Comment Link],
    CreationDate AS [Creation Date]
FROM
    Comments    
WHERE
    UserId = @MyUserID AND
    UPPER(Text) LIKE '%' + @CommentText + '%'
ORDER BY
    CreationDate
DESC

Enter Parameters

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