Problem with FULLTEXT Search (CONTAINS)

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)

Problem with FULLTEXT Search (CONTAINS)

Author

Topic

ankitbhurat
Starting Member

9 Posts

Posted - 2007-12-11 : 08:20:21

Hello All

I am doing FREETEXT search in my Database.

I have indexed my table (Article_ArticleContent) and included some of the columns.

However, executing the query do not returns any records:

SELECT
cArticleTitle, cShortDescription
FROM
Article_ArticleContent
WHERE CONTAINS
(cArticleTitle,' "a*" ');

Although executing the following query, it returns me the correct number of records:

select cArticleTitle, cShortDescription
from dbo.Article_ArticleContent
where cArticleTitle LIKE 'a%'

Can some1 please let me know if I am missing something in Indexing or in the SELECT query.

Ankit

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2007-12-11 : 09:16:41

Your syntax looks OK , could you please conbfirm 1)are the right columns indexed 2)are there any rows in the full text indices?

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-12-11 : 09:29:03

isn't "a" a noise word?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out

ankitbhurat
Starting Member

9 Posts

Posted - 2007-12-11 : 23:17:57

1) Yes the right columns are index, because they were not then sql server prompts an error (2) yes there are rows, in the table. The 2nd Select query return the correct @ of records.

Ankit

quote:
Originally posted by jackv

Your syntax looks OK , could you please conbfirm 1)are the right columns indexed 2)are there any rows in the full text indices?

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

ankitbhurat
Starting Member

9 Posts

Posted - 2007-12-11 : 23:19:01

No I have not added a to the noise list. Also if i change it to something else, the problem persists.
Ankit

quote:
Originally posted by spirit1

isn't "a" a noise word?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out

ankitbhurat
Starting Member

9 Posts

Posted - 2007-12-12 : 03:53:03

Hey Guys,

Solved the problem. Actually, I did not had enabled "Enable Full Text Index..."

Thanks to you, for your time.

Ankit

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources