a problem related to full-text search

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erwin Leonardi - 19 Mar 2008 04:58 GMT

Hi all, I need a help for a problem related to full-text search.
Suppose I have Table A and Table B as following.

Table A
ID Data
-------------------------
1 W1 W2 W3
2 W2 W4
3 W3 W1 W5
4 W4 W5

Table B
ID Keyword
-------------------------
1 W1
2 W5

Can I use full-text search to find records in table A whose [Data]
contains [B.Keyword]?

Thanks

Reply to this Message

Randeep Sawhney - 08 Apr 2008 16:38 GMT

Yes it is possible but yu maynot use a traditional join.

What you will haev to do is construct the keywrod from table B into a
fulltext searchable string - for e.g. uyo want to return records from table A
whch have both W1 and W5 in tableA.Data.

For this you willl have to do

DECLARE @strKeyword Varchar (255)
SET @strKeyword = 'W1 AND W5'

SELECT A.* from ContainsTable (TableA, *, strKeyword)

So in above you have to contruct the strKeyword from tableB.Keyword to make
this work

Hope this helps in solving your problem.

Cheers
Randeep

> Hi all, I need a help for a problem related to full-text search.
> Suppose I have Table A and Table B as following.
[quoted text clipped - 17 lines]
>
> Thanks

Reply to this Message