Search post where comment text like '...'

0

Please login or register to vote for this query.

(click on this box to dismiss)

Also included Score and text

Craft CMS

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

SELECT Id AS [Comment Link], Score, Text 
  FROM Comments 
 WHERE UPPER(Text) LIKE UPPER('%##CommentText##%')
 and CreationDate > '01/01/2020'
 ORDER BY Score ASC

Enter Parameters

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