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 builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors
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