Comments mentioning "nice" etc.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

select Comments.Id as [Comment Link], Comments.UserId as [User Link], Posts.ClosedDate as Closed, Comments.CreationDate from Comments
  inner join Posts on Comments.PostId = Posts.Id
  where (
      lower(Text) like '%nice%' or
      lower(Text) like '%great%' or
      lower(Text) like '%excellent%' or
      lower(Text) like '%fantastic%' or
      lower(Text) like '%well%' or
      lower(Text) like '%good%' or
      lower(Text) like '%lovely%'
    ) --and Comments.CreationDate > '2020-06-13'
  order by Comments.CreationDate DESC

Enter Parameters

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