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
Post a Comment