Language name appearing on own line

1

Please login or register to vote for this query.

(click on this box to dismiss)

Potential ChatGPT posts

Islam Meta

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

SELECT
  Id as [Post Link],
  Body
FROM Posts
WHERE 
  PostTypeId=2
  AND DATEDIFF(d, CreationDate, GETDATE()) < ##DayLimit?3*7##
  AND (
  -- NOTE: CSS and HTML tend to give too many false positives
    Body LIKE '%<p>javascript</p>%'
    OR Body LIKE '%<p>java</p>%'
    OR Body LIKE '%<p>lua</p>%'
    OR Body LIKE '%<p>php</p>%'
    OR Body LIKE '%<p>xml</p>%'
    OR Body LIKE '%<p>python</p>%'
    OR Body LIKE '%<p>sql</p>%'
    OR Body LIKE '%<p>less</p>%'
    OR Body LIKE '%<p>scss</p>%'
    OR Body LIKE '%<p>bash</p>%'
    OR Body LIKE '%<p>plaintext</p>%'
  )

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results