Finding bad answers through comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

A lexical search method

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

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

SELECT TOP 1000  C.Id AS [Comment Link],
C.CreationDate as DateTime,
P.LastEditDate as DateTime
FROM Comments C, Posts P
Where (
(C.Text LIKE '%tex %' or C.Text LIKE '%LaTeX%') and (C.Text LIKE '%read%' or C.Text LIKE '%use%' ) AND
  C.PostID = P.ID AND
  P.ClosedDate IS NULL
)
Order By C.CreationDate

Enter Parameters

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