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

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 + '%'

view current version

edited jan 22 17

created jan 22 17 rene