Posted - 02/20/2013 : 12:41:50
| I am pretty sure there is a way to run a text search for words that are in the same sentence but can't seem to get the syntax right. I am working with Rapid SQL and trying to use a verity function "<many><sentence>(third, ventricle, pilocytic, astrocytoma)".
I need to find results where all these words are in the same sentence within a large text area. So an example of what I am working with is:
table2 t2(this is where the text is located)
date between 11/1/2012 and 12/1/2012
and t1.rep_id = t2.rep_id
and this is where I stumble on looking for the keywords in t2 where third, ventricle, pilocytic, astrocytoma are in the text AND in the same sentence.
Any advice is greatly appreciated.