0

Please login or register to vote for this query.

(click on this box to dismiss)

A lexical search method

Q&A for network engineers

-- 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, P.Posttypeid
FROM Comments C, Posts P
Where (
  YEAR(C.CreationDate) = 2012 AND
  MONTH(C.CreationDate) > 5 AND
  C.Text LIKE '%@%@%' AND
  C.PostID = P.ID AND
  P.ClosedDate IS NULL
)
Order By Month

fork query

edited nov 28 12 AbdulFattah

created feb 27 11 sysadmin1138