Find comments by user and text

2

Please login or register to vote for this query.

(click on this box to dismiss)

You can enter a user id and some text to search for in their comments. Result contains links to the post, the comment and displays the text.

Stack Overflow на русском

Вопросы и ответы для программистов

select
    Id [Comment Link],
    Postid [Post Link],
    convert(char(10), CreationDate, 102) Date,
    Text
from Comments
where UserId = ##UserId##
and Text like '%##Text##%'

Enter Parameters

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