2

Please login or register to vote for this query.

(click on this box to dismiss)

A lexical search method

Q&A about the site for biology researchers, academics, and students

-- Finding bad answers through comments
-- A lexical search method

SELECT TOP 1000  c.PostId AS [Post Link], YEAR(C.CreationDate) AS Year, Month(C.CreationDate) AS Month, c.text AS Body
FROM Comments C
INNER JOIN Posts A ON C.PostId = A.ID
INNER JOIN Posts Q ON A.ParentId = Q.ID
Where (
  C.Text LIKE '%should be a comment%' AND
  Q.ClosedDate IS NULL
)
Order By Year, Month

fork query

edited jun 22 12 robert42

created feb 27 11 sysadmin1138