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"

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"


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

Enter Parameters

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