SELECT c.Text AS "Comment", c.CreationDate AS "Comment Da...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  c.Text AS "Comment",
  c.CreationDate AS "Comment Date", 
  u.DisplayName AS "User Name", 
  c.PostId AS [Post Link]
FROM Comments c
  JOIN Users u ON u.Id = c.UserId
WHERE c.Text LIKE '%##searchString1##%'

Enter Parameters

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