Comments by keword

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

DECLARE @UserId int = ##UserId##
DECLARE @KeyWord nvarchar(64) = ##ContainedText:string##

select Score, Text as [Comment Link], PostId as [Post Link], CreationDate as Date
from Comments 
where UserId = @UserId and Text LIKE @KeyWord ORDER BY Score DESC

Enter Parameters

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