List of Favorites for a UserId containing some Text string

0

Please login or register to vote for this query.

(click on this box to dismiss)

Query Favorites by UserId and Text contents. Text searches use a % wildcard by default.

Stack Overflow

Q&A for professional and enthusiast programmers

-- List of Favorites for a UserId containing some Text string
-- Query Favorites by UserId and Text contents.  Text searches use a % wildcard by default.

SELECT Posts.id as [Post Link], Posts.Tags as [Tagged With]

FROM Votes, Posts

WHERE
     (Votes.UserId=##User:int##) AND
     ((Posts.Tags LIKE '%<##Text##>%') OR
     (Posts.Title LIKE '%##Text##%') OR
     (Posts.Body LIKE '%##Text##%'))

Enter Parameters

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