A lexical search method
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