Search your own comments for a string. Results show the comment, its score, the date, and a link to the post, newest comments first.
Q&A for professional and enthusiast programmers
DECLARE @pattern nvarchar(100) = UPPER(##Pattern:string##) SELECT Id AS [Comment Link], Score, CreationDate, PostId AS [Post Link] FROM Comments WHERE UserId = ##UserID## AND UPPER(Text) LIKE '%' + @pattern + '%' ORDER BY CreationDate DESC