Using full text search with keywords from a column

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Using full text search with keywords from a column

Author

Topic

salavat_a
Starting Member

5 Posts

Posted - 2007-07-24 : 23:15:21

Hi all

I am trying to find a solution for using a full text search from a keyword column. The scenario is email subscription service, where the users specify keyword as a subscription parameter. The desire is to get all subscription data in one select statement. To see what I am trying to do please look at the example below:

SELECT * FROM SubscriberTable st INNER JOIN
DataTable dt ON {Some Condition}
WHERE CONTAIN (dt.TextColumn, st.KeywordColumn)

Any help is greatly appreciated
Regards,
Salavat Akhmediev

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-25 : 05:49:43

there is no contain only CONTAINS.

also look into CONTAINSTABLE, FREETEXT and FREETEXTTABLE

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

salavat_a
Starting Member

5 Posts

Posted - 2007-07-25 : 06:45:10

Right you are - my quick fingers caused the spelling error. The problem is non of those accept a column name as a parameter.

angiedawnf
Starting Member

1 Post

Posted - 2009-06-03 : 12:51:01

I realize this is an old topic, but I am trying to accomplish the same thing. Does anyone have any suggestions?

Thanks.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources