Q&A about the site for administrators, end users, developers and designers for Craft CMS
SELECT c.text, c.id AS [Comment Link], creationdate FROM comments c WHERE c.text LIKE '%##keyword1##%' AND len(c.text) <= 100 ORDER BY creationdate DESC