Search UserId's Favorites for Tags with <TagName> (Wildcard)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Search UserId's Favorites for a Tag string. Tag searches use a % wildcard by default.

Vegetarianism Meta

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

-- Search UserId's Favorites for Tags with <TagName> (Wildcard)
-- Search UserId's Favorites for a Tag string.  Tag searches use a % wildcard by default.

SELECT top 100 Posts.id as [Post Link], u.Reputation as [Rep], Posts.Tags as [Tagged With]

FROM Posts, Users u
cross join Users

WHERE
     (u.Reputation <= 10) AND
     (Posts.Tags LIKE '%swift%')

ORDER BY Posts.CreationDate DESC

Enter Parameters

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