MathJax in titles

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

SELECT
  *
FROM
  Posts
WHERE

  -- First interval. The limit date is 2019-06-23
  CreationDate > '2019-04-30'
  AND CreationDate < '2019-06-24'
  
  
  
   -- Questions only:
  AND (ParentID IS NULL)
  AND (
    LOWER(Title) Like LOWER('% ##words## %')
    OR
    LOWER(Title) Like LOWER('% ##words##')
    OR
    LOWER(Title) Like LOWER('##words## %')
    OR
    LOWER(Title) Like LOWER('% ##words##-%')
    OR
    Lower(Title) Like LOWER('%-##words## %')
    OR
    Lower(Title) Like LOWER('%\(##words##\)%')
   -- OR
   -- Lower(Title) Like LOWER('%\[##words##\]%')
   -- OR
   -- Lower(Title) Like LOWER('%\{##words##\}%')
    
    
    OR
    LOWER(Body) Like LOWER('% ##words## %')
    OR
    LOWER(Body) Like LOWER('% ##words##')
    OR
    LOWER(Body) Like LOWER('##words## %')
    OR
    LOWER(Body) Like LOWER('% ##words##-%')
    OR
    Lower(Body) Like LOWER('%-##words## %')
   -- OR
   -- Lower(Body) Like LOWER('%\(##words##\)%')
   -- OR
   -- Lower(Body) Like LOWER('%\[##words##\]%')
   -- OR
   -- Lower(Body) Like LOWER('%\{##words##\}%')
  )
ORDER BY
  CreationDate

Enter Parameters

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