Search UserId's Favorites for text contents (case-insensitive). Results are sorted (descending) by Question score.
Q&A for professional and enthusiast programmers
-- Search UserId's Favorites containing some Text (Wildcard) -- Search UserId's Favorites for text contents (case-insensitive). Results are sorted (descending) by Question score. 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 (Votes.UserId=##User:int##) AND ((lower(Posts.Tags) LIKE lower('%<##Text##>%')) OR (lower(Posts.Title) LIKE lower('%##Text##%')) OR (lower(Posts.Body) LIKE lower('%##Text##%'))) ORDER BY Posts.Score DESC