SELECT TOP 5000 C.Id AS [Comment Link], P.Score, C.Text F...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 5000
  C.Id AS [Comment Link],
  P.Score,
  C.Text
FROM Comments C
JOIN Posts P ON P.Id = C.PostId
WHERE
  C.Text COLLATE Latin1_General_BIN LIKE '%[sS]ave%'
  AND (
    C.Text COLLATE Latin1_General_BIN LIKE '%[lL]ife%' OR
    C.Text COLLATE Latin1_General_BIN LIKE '%[dD]ay%' OR
    C.Text COLLATE Latin1_General_BIN LIKE '%[hH]our%' OR
    C.Text COLLATE Latin1_General_BIN LIKE '%[wW]eek%'
  )
  AND LEN(C.Text) <= 50
ORDER BY P.Score Desc
;

Enter Parameters

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