FULL TEXT SEARCH

FULL TEXT SEARCH - PROBLEM

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

in da club - 31 Oct 2007 16:11 GMT

I have query like that

SELECT

Urun_ID

,Urun_Ad

FROM TBL_URUNLER

WHERE CONTAINS(Urun_Ad, '"*mta1000-*"' )

it returns

62 MTA1000-1

When i chance the search phrase mta1000-1

it returns nothing.

Urun_Ad is defined as NVARCHAR(50)

in my tbl_urunler table .

I rebuilded my fulltextcatalog before running my query

What can be the problem ?

Reply to this Message

Daniel Crichton - 31 Oct 2007 18:30 GMT

in wrote on Wed, 31 Oct 2007 17:11:39 +0200:

> I have query like that

> SELECT
> Urun_ID
> ,Urun_Ad
> FROM TBL_URUNLER
> WHERE CONTAINS(Urun_Ad, '"*mta1000-*"' )

Why are you using *? It doesn't work like that - FTS breaks up the indexed
columns into words, you can use a * at the end of a term for searching for
words starting with the term but it's ignored for the start. Also some
characters are ignored, so the hyphen is probably unnecessary too. This is
basically turned into

CONTAINS(Urun_Ad,'"mta1000*"')

and could also be written as

CONTAINS(Urun_Ad,'"mta1000"')

and it would still find the same row(s).

> it returns
> 62 MTA1000-1

> When i chance the search phrase mta1000-1
> it returns nothing.

What is the actual CONTAINS clause you are using? If it's

CONTAINS(Urun_Ad,'"mta1000-1"')

then if the 1 is not indexed (as it's in the noise word file by default),
then it won't find that "phrase" because the 1 isn't indexed. "mta1000-1" is
the same as looking for "mta1000 1", and if the 1 isn't indexed then the
phrase won't be found.

What is in your noise words list?

Dan

Reply to this Message

Hilary Cotter - 01 Nov 2007 00:25 GMT

Is 1 in your noise word list?

Signature

RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>I have query like that
>
[quoted text clipped - 23 lines]
>
> What can be the problem ?

Reply to this Message