Search posts by UserId, comment text


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for legal professionals, students, and others with experience or interest in law

SELECT Posts.Id AS [Post Link], PostTypes.Name, Users.DisplayName 
  FROM Comments INNER JOIN Posts ON Comments.PostId=Posts.Id INNER JOIN PostTypes ON Posts.PostTypeId=PostTypes.Id INNER JOIN Users ON Posts.OwnerUserId=Users.Id
 WHERE UPPER(Text) LIKE UPPER('%##CommentText##%')
   AND UserId = '##UserId##'

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results