1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

-- https://meta.stackoverflow.com/questions/288160/no-thanks-damn-it
-- https://meta.stackoverflow.com/questions/267490/thanks-in-a-comment
-- https://meta.stackoverflow.com/a/367472/11107541
-- https://meta.stackoverflow.com/questions/365273/automatically-removing-comments-that-arent-just-thank-you-and-1-nice-ans
SELECT TOP 10000
  C.Id as [Comment Link]
  ,C.Text
  ,C.CreationDate
FROM Comments C
WHERE
  C.Score = 0
  AND C.Text COLLATE Latin1_General_BIN LIKE '%[tT]hank%'
  AND C.Text COLLATE Latin1_General_BIN LIKE '%work%'
  AND NOT C.Text COLLATE Latin1_General_BIN LIKE '%not work%'
  AND NOT C.Text COLLATE Latin1_General_BIN LIKE '%n''t work%'
  AND LEN(C.Text) < 50
ORDER BY C.CreationDate ASC
;

fork query

edited oct 4

created sep 22 starball