0

Please login or register to vote for this query.

(click on this box to dismiss)

Lists (top 2000) questions with Hi/Hello/Thanks/Thx in body

Q&A for aircraft pilots, mechanics, and enthusiasts

-- Questions with signatures [Hi/thanks]
-- Lists (top 2000) questions with Hi/Hello/Thanks/Thx in body
select top 2000 Id as [Post Link]
from posts
where posttypeid = 1 
  and (
        ((
          body like '%thank%' or
          body like '%thx%') and body not like '%thanks to%') or
       body like 'Hi%' or 
       body like 'Hello%' or
       body like '%best regards%' or
       body like '%kind regards%')
-- The following Aviation.SE questions are false positives 
  and id not in (8101, 29789,11174,9593)

fork query

edited jul 12 16 Who?

created sep 17 10 Benjol