SELECT COUNT(CASE WHEN Body LIKE '%http://stackoverflow.c...

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
  COUNT(CASE WHEN Body LIKE '%http://stackoverflow.com%' THEN 1 ELSE null END) so_https_links,
  COUNT(CASE WHEN Body LIKE '%://stackoverflow.com%' THEN 1 ELSE null END) so_any_links,
  COUNT(*) total
FROM
  Posts p
WHERE
  CreationDate >= '2017-03-08'

Enter Parameters

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