5

Please login or register to vote for this query.

(click on this box to dismiss)

Please Note: This query only searches comments left within the last week or so

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

SELECT
    Id AS [Comment Link],
    Score,
    CreationDate as Date
FROM
    Comments
WHERE
    text like '%##Word##%' COLLATE SQL_Latin1_General_CP1_CI_AS
AND
    CreationDate > '2015-02-22T00:00:00.000'
ORDER BY
    CreationDate DESC

fork query

edited mar 8 15 bluet

created mar 14 14 jon.doe12894