0

Please login or register to vote for this query.

(click on this box to dismiss)

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##%' AND
c.Text LIKE '%##searchString2##%' AND
c.Text LIKE '%##searchString3##%' AND
c.UserId = '##UserId##'

fork query

edited aug 13 22

created aug 13 22 terdon