0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT
  *
FROM
  Posts
WHERE

  -- (01) The limit date is 2019-06-23
  CreationDate > '2019-03-31'
  AND CreationDate < '2019-06-24'
  
  -- (02)
  --CreationDate > '2019-01-31'
  --AND CreationDate < '2019-04-01'
  
  -- (03)
  --CreationDate > '2018-11-30'
  --AND CreationDate < '2019-02-01'
  
  -- (04)
  --CreationDate > '2018-09-30'
  --AND CreationDate < '2018-12-01'
  
  -- (05)
  --CreationDate > '2018-07-31'
  --AND CreationDate < '2018-10-01'
  
  -- (06)
  --CreationDate > '2018-03-31'
  --AND CreationDate < '2018-08-01'
  
  -- (07)
  --CreationDate > '2018-04-30'
  --AND CreationDate < '2018-09-01'
  
  -- (08)
  --CreationDate > '2018-01-31'
  --AND CreationDate < '2018-05-01'
  
  -- (09)
  --CreationDate > '2017-12-31'
  --AND CreationDate < '2018-02-01'
  
  -- (10)
  --CreationDate > '2017-09-30'
  --AND CreationDate < '2018-01-01'
  
  -- (11)
  --CreationDate > '2017-06-30'
  --AND CreationDate < '2017-10-01'
  
  -- (12)
  --CreationDate > '2017-04-30'
  --AND CreationDate < '2017-07-01'
  
  -- (13)
  --CreationDate > '2016-12-31'
  --AND CreationDate < '2017-05-01'
  
  -- (14)
  --CreationDate > '2016-09-30'
  --AND CreationDate < '2017-01-01'
  
  -- (15)
  --CreationDate > '2016-06-30'
  --AND CreationDate < '2016-10-01'
  
  -- (16)
  --CreationDate > '2016-03-31'
  --AND CreationDate < '2016-07-01'
  
  -- (17)
  --CreationDate > '2015-12-31'
  --AND CreationDate < '2016-04-01'
  
  -- (18)
  --CreationDate > '2015-08-31'
  --AND CreationDate < '2016-01-01'
  
  -- (19)
  --CreationDate > '2015-05-31'
  --AND CreationDate < '2015-09-01'
  
  -- (20)
  --CreationDate > '2015-01-31'
  --AND CreationDate < '2015-06-01'
  
  -- (21)
  --CreationDate > '2014-10-31'
  --AND CreationDate < '2015-02-01'
  
  -- (22)
  --CreationDate > '2014-06-30'
  --AND CreationDate < '2014-11-01'
  
  -- (23)
  --CreationDate > '2014-03-31'
  --AND CreationDate < '2014-07-01'
  
  -- (24)
  --CreationDate > '2013-12-31'
  --AND CreationDate < '2014-04-01'
  
  -- (25)
  --CreationDate > '2013-09-30'
  --AND CreationDate < '2014-01-01'
  
  -- (26)
  --CreationDate > '2013-04-30'
  --AND CreationDate < '2013-10-01'
  
  -- (27)
  --CreationDate > '2012-12-31'
  --AND CreationDate < '2013-05-01'
  
  -- (28)
  --CreationDate > '2012-06-30'
  --AND CreationDate < '2013-01-01'
  
  -- (29)
  --CreationDate > '2011-12-31'
  --AND CreationDate < '2012-07-01'
  
  -- (30) FAILED FOR BOTH
  --CreationDate > '2010-12-31'
  --AND CreationDate < '2012-01-01'
  
  -- (31)
  --CreationDate > '2009-12-31'
  --AND CreationDate < '2011-01-01'
  
  -- (32)
  --CreationDate < '2010-01-01'
  
  
  AND 
  (
    LOWER(Body) Like LOWER('%Technical Debt%')
    OR
    LOWER(Title) Like LOWER('%Technical Debt%')
  )
  AND (
    LOWER(Title) LIKE LOWER('%[^a-z]##words##[^a-z]%')
    OR
    LOWER(Title) LIKE LOWER('%[^a-z]##words##')
    OR
    LOWER(Title) LIKE LOWER('##words##[^a-z]%')
    
    OR
    LOWER(Body) LIKE LOWER('%[^a-z]##words##[^a-z]%')
    OR
    LOWER(Body) LIKE LOWER('%[^a-z]##words##')
    OR
    LOWER(Body) LIKE LOWER('##words##[^a-z]%')
  )
ORDER BY
  CreationDate

fork query

edited jul 29 jon.doe31862

created mar 12 anonymous