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 those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
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