full text search - SqlServer 2008 - deleting rows containing terms found in a black list table -


i have 2 tables, 1 list of strings , other contains list of black listed words. wish find rows in first table string contains word second.

using statement created following script , worked:
select a.string
a
left join blacklist b on a.string '%' + b.term + '%'
b.term null

i wanted use full text search better performance. looking way this: select a.string
a
left join blacklist b on contains(a.string, b.term)
b.term null

my research on web discovered not possible, way of doing this?

you need run row row try cross apply. no match = no row cross apply query same left join..is null

select    a.string    a    cross apply    (select b.term blacklist b contains(a.string, b.term)) foo 

Comments

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -