0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for pro webmasters

-- Search Comments by Text

select
  c.postid as [Post Link], c.id,c.text,c.score
from 
  comments c
inner join Posts p on
  postid = p.id
where 
  p.PostTypeId=1 and
  p.OwnerUserId != c.UserId and
  text like '%accept%' and text like '%rate%'
order by 
  c.Score desc

fork query

created jun 20 11 YOU