Q&A for professional and enthusiast programmers
-- also displays both related users (main text + comment) -- CommentText: Enter keyword for search in comments: SELECT c.PostId AS [Post Link], COALESCE(u.DisplayName, c.UserDisplayName) AS [User], c.CreationDate, c.Id AS [Comment Link] --, c.Text -- Comment link also shows text. FROM Comments c LEFT JOIN Users u ON c.UserId = u.id WHERE c.Text like '%##CommentText##%' ORDER BY c.CreationDate