Comments on questions containing the substring "close"

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.Id as [Comment Link], c.CreationDate, c.Score from Comments c
  INNER JOIN Posts q ON
  q.Id = c.PostId
  where (
      lower(Text) like '%close%'
      and q.PostTypeId = 1
    )
  order by c.CreationDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results