Search UserId's Questions & Answers for a Text string

0

Please login or register to vote for this query.

(click on this box to dismiss)

Search UserId's Questions & Answers for a Text string. Text searches use a % wildcard by default; searches are case-insensitive

Русский язык

Q&A for лингвистов, этимологов, и энтузиастов русского языка

-- Search UserId's Questions & Answers for a Text string
-- Search UserId's Questions & Answers for a Text string.  Text searches use a % wildcard by default; searches are case-insensitive

SELECT Posts.OwnerUserId as [User Link], Posts.id as [Post Link], Posts.PostTypeId as [Post Type], Posts.Score as [Score], Posts.Tags as [Tagged With]

FROM Posts

WHERE (lower(Posts.Body) LIKE lower('%##Text2##%')) and Posts.OwnerUserId = 5426 
     

GROUP BY Posts.OwnerUserId, Posts.id, Posts.PostTypeId, Posts.Score, Posts.Tags

ORDER BY Posts.PostTypeId ASC, Posts.Score DESC

Enter Parameters

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