Blog References

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

With link_start as (
SELECT [id], 
CHARINDEX('http://blog.stackoverflow.com', body) pos, body
FROM posts
WHERE BODY like '%http://blog.stackoverflow.com%')
SELECT id ,
pos,
CHARINDEX('">', body, pos) end_pos,
case WHEN (CHARINDEX('">', body, pos) ) <> 0 THEN 
substring(body, pos, CHARINDEX('">', body, pos)  - pos) END
FROM link_start

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results