Also included Score and text
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