Answers who's question is tagged 'regex' and is likely just a new regex

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  a.Id as [Post Link],
  a.Score as [Answer Score],
  LEN(a.Body) as [Answer Length],
  a.Body as [Answer Body]
FROM Posts a
INNER JOIN Posts q 
  ON q.Id = a.ParentId
WHERE
  a.PostTypeId = 2 AND
  q.Tags LIKE '%<regex>%' AND
  (
    a.Body LIKE '<pre><code>%' OR
    a.Body LIKE '<p><code>%'
  ) AND
  LEN(a.Body) <= 100
GROUP BY
  a.Id, a.Score, a.Body
ORDER BY
  a.Score DESC,
  LEN(a.Body) ASC

Enter Parameters

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