How to find all topics on stackoverflow that contain one of the words from a list

0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackoverflow.com/questions/292031/how-to-find-all-topics-on-stackoverflow-that-contain-one-of-the-words-from-a-lis/342049#342049

Stack Overflow

Q&A for professional and enthusiast programmers

-- --search:separate terms with a comma
declare  @searchterms nvarchar(200) = ##search:string##

select distinct top 100
       id as [Post Link]
from posts p
inner join string_split(@searchterms,',') as st on p.body like '%' + st.value + '%'
where creationdate > '2016-01-01'
and score > 10

Enter Parameters

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