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