Posts with <code> or <pre> tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

finds posts that currently contain <code> or <pre> in raw markdown ideally indenting or backticks should be used instead

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT p.Id AS [ Post Link ]
FROM Posts P
WHERE (
      PostTypeId = 1 OR
      PostTypeID = 2
      )
      AND (
      p.Body LIKE '%<code>%' OR
      p.Body LIKE '%<pre>%'
      )
ORDER BY p.CreationDate DESC

Enter Parameters

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