0

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 scholars and enthusiasts of literature

-- Finding bad answers
-- A lexical search method

SELECT TOP 1000 P.Score, p.Id AS [Post Link], YEAR(p.CreationDate) AS Year, Month(p.CreationDate) AS Month, p.Body AS Body
FROM Posts AS P, Users AS U
Where (
  P.PostTypeID = 2 AND 
  P.Score = 0 AND 
  P.Body LIKE '%exactly the same%' 
  AND P.ClosedDate IS NULL)

fork query

created feb 8 11 sysadmin1138