Posts with possibly misformatted code

0

Please login or register to vote for this query.

(click on this box to dismiss)

finds instances of "<pre><code>" (the result of using hacky HTML instead of Markdown)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Posts with possibly misformatted code
-- finds instances of "<pre><code>" (the result of using hacky HTML instead of Markdown)

select top 50
id as [Post Link],
creationdate
from posts
where
(body like '%<pre>' + CHAR(13) + '<code>%'
or body like '%<pre>' + CHAR(10) + '<code>%'
or body like '%<pre>' + CHAR(13) + CHAR(10) + '<code>%'
or body like '%<code>' + CHAR(13) + '<pre>%'
or body like '%<code>' + CHAR(10) + '<pre>%'
or body like '%<code>' + CHAR(13) + CHAR(10) + '<pre>%')

Enter Parameters

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