Search Python Guru's Questions & Answers for a Text string

1

Please login or register to vote for this query.

(click on this box to dismiss)

Search Raymond Hettinger / Alex Martelli's Questions & Answers for a Text string. Text searches use a % wildcard by default; searches are case-insensitive

Stack Overflow

Q&A for programmers

-- Search Python Guru's Questions & Answers for a Text string
-- Search Raymond Hettinger / Alex Martelli's Questions & Answers for a Text string.  Text searches use a % wildcard by default; searches are case-insensitive

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

FROM Posts

WHERE
     ((Posts.OwnerUserId=1001643) OR (Posts.OwnerUserId=95810)) AND
     ((lower(Posts.Tags) LIKE lower('%<##Text##>%')) OR
     (lower(Posts.Title) LIKE lower('%##Text##%')) OR
     (lower(Posts.Body) LIKE lower('%##Text##%')))

GROUP BY Posts.id,  Posts.OwnerUserId, 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