1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for developers and researchers interested in open data

SELECT
  Id AS [Post Link],
  Score,
  SUBSTRING(Body, CHARINDEX('<img src="', Body), 100) AS Img,
  Body
FROM Posts
WHERE Body LIKE '%<img src="%'
ORDER BY Score DESC, Id DESC;

fork query

edited may 25 20

created may 25 20 peterh (2)