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 about the site for system and network administrators
DECLARE @pattern nvarchar(600) = 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