Please Note: This query only searches comments left within the last week or so
Q&A for enthusiasts and scholars of mythology and folklore
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-01-04T00:00:00.000' ORDER BY CreationDate DESC