Fuzzy comment search

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

SELECT 
    c.CreationDate,
    c.Id as [Comment Link]
FROM 
    Comments as c LEFT OUTER JOIN Comments as t ON t.PostId = c.PostId
WHERE
    t.TEXT LIKE ##threadneedle:string##
    AND c.TEXT LIKE ##needle:string##
ORDER BY 
    c.CreationDate DESC

Enter Parameters

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