Possible dupes

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 *
FROM Comments
  INNER JOIN Posts Question
    ON Comments.UserId = Question.OwnerUserId
  INNER JOIN PostTags
    ON Question.Id = PostTags.PostId
  INNER JOIN Tags
    ON PostTags.TagId = Tags.Id
 /* INNER JOIN Posts Answer
    ON Comments.PostId = Answer.Id*/
WHERE Tags.Id = 130 -- Looking only for 'story-ident'
  /*AND Question.AcceptedAnswerId <> Answer.Id -- answer not accepted*/
  AND 
  (
    LOWER(Comments.Text) LIKE LOWER('%thank%') OR
    LOWER(Comments.Text) LIKE LOWER('%yes%') OR
    LOWER(Comments.Text) LIKE LOWER('%that_s it%')
   )

Enter Parameters

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