Is there any way to show all screenshots I have posted on SO?


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 concat( 
         '<a href="'
       , id
       , '">'
       , title
       , '</a><br>'
       , left(img, convert(int, charindex('>', img, 36)) )
       , '<br>')
 --  , charindex('>',img, 36)
select substring(
         convert(int, patindex(N'%<img src="', p.body)),
         len(p.body)) img
      , q.title
from posts p
inner join posts q on = coalesce(p.parentid,
where p.owneruserid = 3437787
and p.body like '%<img src="" alt="%>%'
) data

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results