Search posts by UserId, comment text

0

Please login or register to vote for this query.

(click on this box to dismiss)

Law

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

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