Search UserId's Favorites for a Tag string. Tag searches use a % wildcard by default.
Q&A for professional and enthusiast programmers
-- 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 Posts.id as [Post Link], Posts.Score as [Score], Posts.Tags as [Tagged With] FROM Votes, Posts WHERE (Votes.PostId=Posts.Id) AND (Votes.VoteTypeId = 5) AND (Posts.Tags LIKE '%##TagName##%') ORDER BY Posts.Score DESC