Finding bad answers through comments

3

Please login or register to vote for this query.

(click on this box to dismiss)

A lexical search method

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- 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, Posts P
Where (
  C.Text LIKE '%not%programming%' AND
  C.PostID = P.ID AND
  P.ClosedDate IS NULL
)
Order By Year, Month

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results