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


Please login or register to vote for this query.

(click on this box to dismiss)

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

Switch to meta site
loading Hold tight while we fetch your results