Find posts by you that contain images

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.

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##%';

created may 14 11