1

Please login or register to vote for this query.

(click on this box to dismiss)

Find comments of a specific user by text.

Q&A for professional and enthusiast programmers

SELECT
c.PostId as [Post Link],
c.Score,
c.Text,
c.CreationDate

FROM Comments c
WHERE
(c.UserId=##User:int##) AND
lower(c.Text) LIKE lower(N'%##Text##%')

fork query

edited nov 26 20 GNU.Supporter

created mar 1 12 Remou