Simple comment search

5

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT COALESCE(Score, 0) AS Score,
       PostId             AS [Post Link],
       Id                 AS [Comment Link],
       UserId             AS [User Link]
FROM   Comments
WHERE  Text LIKE '%' + ##SearchString:string## + '%' ESCAPE ##EscapeChar:string?\##
ORDER  BY CreationDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results