Re: Search and Index Question
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Fri, 7 Sep 2007 20:57:50 -0400
I am sorry I misunderstood you question. Basically the brackets are not
indexed and are ignored in searches.
--
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
"ChuSoft" <cc3412@xxxxxxxxxxxxxxxx> wrote in message
news:OzVbyxa8HHA.4736@xxxxxxxxxxxxxxxxxxxxxxx
Try it and it returns rows that does NOT have the "(some text here)".
It all rows that have "some text here"
"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:uf8n$2T8HHA.1204@xxxxxxxxxxxxxxxxxxxxxxx
full text index your table on the columns you wish to search and then do
this
select * from tablename where freetext(*,'"(specific text here)")
--
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
"ChuSoft" <cc3412@xxxxxxxxxxxxxxxx> wrote in message
news:uFWSwoL8HHA.3716@xxxxxxxxxxxxxxxxxxxxxxx
We need to index and search on "(specific text here)".
How can we do a free text search using the above.
.
- Follow-Ups:
- Re: Search and Index Question
- From: ChuSoft
- Re: Search and Index Question
- References:
- Search and Index Question
- From: ChuSoft
- Re: Search and Index Question
- From: Hilary Cotter
- Re: Search and Index Question
- From: ChuSoft
- Search and Index Question
- Prev by Date: Re: Search and Index Question
- Next by Date: Space Required to store a file in database
- Previous by thread: Re: Search and Index Question
- Next by thread: Re: Search and Index Question
- Index(es):
Relevant Pages
|
