Find posts by you that contain images

1

Please login or register to vote for this query.

(click on this box to dismiss)

Looks for posts owned by the UserId that contain images by querying for the string "<img" and an optional specific host.

Super User

Q&A for computer enthusiasts and power users

-- Find posts by you that contain images
-- Looks for posts owned by the UserId that contain images by querying
-- for the string "<img" and an optional specific host.

SELECT
       Body, OwnerUserId
FROM   Posts
WHERE  OwnerUserId =  ##UserId## AND Body LIKE '%<img%src="##ImageHost##%';

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached