0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Looks for comments with the following texts:
-- "this is invalid"
-- "this answer is invalid"
-- "should be deleted"

select
  Comments.Id as [Comment Link],
  Comments.PostId as [Post Link],
  Comments.UserId as [User Link]
from
  Comments
  inner join
  Posts on Posts.Id = Comments.PostId
where
  Posts.PostTypeId = 2 and (
    Comments.Text like '%this is invalid%' or
    Comments.Text like '%this answer is invalid%' or
    Comments.Text like '%should be deleted%'
  )
order by
  Comments.CreationDate
  asc

fork query

edited jun 9 21

created jun 9 21 caird.coinheringaahing