1

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

created dec 13 11 penningtonthing