Search comments by keyword

1

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

select id, 
'site://questions/' + CAST(postID AS nvarchar) + '/' as [Post Link], 
text
from Comments
where text LIKE '%' + ##keyword:string## + '%' ESCAPE '!' 
AND (##userId:int?0## = 0 OR userID=##userId:int##)
ORDER BY id DESC

-- This query is special, because unlike so many others,
-- it allows you to change the keyword and optionally
-- specify a userId

Enter Parameters

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