Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
SELECT sum(case when Title LIKE '% -- %' then 1 else 0 end) AS [mdash], sum(case when Title LIKE '% <!-- %' then 1 else 0 end) AS [comment], sum(case when Title LIKE '%[a-z0-9]-- %' then 1 else 0 end) AS [decrement], sum(case when Title LIKE '% --[a-z0-9]%' then 1 else 0 end) AS [increment], sum(case when (Title LIKE '%-- %' OR Title LIKE '%--- %') and Title NOT LIKE '% -- %' and Title NOT LIKE '% <!-- %' and Title NOT LIKE '%[a-z0-9]-- %' and Title NOT LIKE '% --[a-z0-9]%' then 1 else 0 end) AS [rest] FROM Posts