1

Please login or register to vote for this query.

(click on this box to dismiss)

Search through a user's comments

Q&A for scientists using computers to solve scientific problems

-- Search user's comments
-- Search through a user's comments

SELECT
  PostId as [Post Link],
  UserId as [User Link],
  CreationDate,
  [Text],
  Score
FROM
    Comments
WHERE
    UserId = ##UserId## AND Text LIKE '%##SearchTerm##%'
ORDER BY
    CreationDate DESC

fork query

created nov 16 10 Amro