0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

DECLARE @limit date = '2021-09-01'

SELECT TOP 100 Id as [Post Link], Body
FROM Posts P
WHERE
  PostTypeId = 1
  AND CreationDate > @limit
  AND (
       LOWER(Body) LIKE '%thank you%'
    OR LOWER(Body) LIKE '%thanks in advance%'
    OR LOWER(Body) LIKE '%thanks for any%'
    OR LOWER(Body) LIKE '%regards%'
    OR LOWER(Body) LIKE '%please help%'
  )
ORDER BY CreationDate DESC

view current version

edited nov 30

created nov 26 Marco.Bonelli