0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

SELECT CONCAT('https://stackoverflow.com/q/',PostId,'#comment',Id,'_',PostId) AS CommentLink,
       *
FROM dbo.Comments
WHERE Text LIKE '%thanks%'
  AND LEN(text) <= 30
  AND CreationDate >= '20240101' --Because this'll take ages to run otherwise
ORDER BY LEN(text) ASC;

fork query

edited dec 9

created dec 9 Larnu