Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
SELECT t.tagname AS [TagName], PATINDEX('%http:%', w.Body) FROM tags t LEFT JOIN Posts w ON t.WikiPostId = w.Id WHERE w.Body LIKE '%http:%'