Search UserId's Favorites for a Tag string. Tag searches use a % wildcard by default.
Q&A about the site 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 WHERE (u.Reputation <= 10) AND (Posts.Tags LIKE '%swift%') AND ParentId is null ORDER BY Posts.CreationDate DESC