MathJax in titles

0

Please login or register to vote for this query.

(click on this box to dismiss)

Hinduism Meta

Q&A about the site for followers of the Hindu religion and those interested in learning more about Hinduism

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'
  
  
  -- Questions only:
  -- AND (ParentID IS NULL)
  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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results