Find posts by you that contain images

0

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.

Craft CMS

Q&A for administrators, end users, developers and designers for Craft CMS

-- 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
       Title AS [Post Link]
FROM   Posts
WHERE  OwnerUserId =  ##UserId## AND Body LIKE '%<img%src="%jp%';

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results