3

How can I utilize data.stackexchange to list all external URLs from own posts on SU?

Background: After reading "I estimate 10% of the links posted here are dead. How do we deal with them?" I tried to check at least my own posts if they have dead links

Questions

  • Does data.stackexchange support regular expressions? Or is like = %myString% my only option? My quick tests said, it doesn't
  • How can I build an output with 2 columns where the first one is the contained URL and the second one the associated post link. I think I have to create my own table beforehand like it's done here

Requirements

  • Find all questions and answers with my userID
  • Use a Regex expression to search for URLs (if possible somehow)
  • If multiple URLs are found in a post, list each URL in a new row
  • Sort by post date ascending (oldest to newest)

Where I'm currently stuck

SELECT
    p.Id as [Post Link]         
FROM    
    Posts p
WHERE 
    p.OwnerUserId = ##UserId##   and
    p.Body like '%http://%'    
ORDER BY p.CreationDate DESC
1
  • data.stackexchange.com/help#faq "You didn't cover my question about _______, what's wrong with you? Well…that's a story for another day. To get help with your Data Explorer question though, or to provide feedback, please ask on Meta Stack Exchange! "
    – DavidPostill Mod
    Aug 9, 2015 at 16:07

0

You must log in to answer this question.

Browse other questions tagged .