Re: Search and Index Question
- From: "ChuSoft" <cc3412@xxxxxxxxxxxxxxxx>
- Date: Mon, 10 Sep 2007 10:57:10 -0500
Is there anyway to index and search on the phrase with brackets?
"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:O2yAoNb8HHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
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: Hilary Cotter
- 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
- Re: Search and Index Question
- From: Hilary Cotter
- Search and Index Question
- Prev by Date: Re: Full-text search content
- Next by Date: Re: Capacity planning and performance tuning - SQL 2005 Full text
- Previous by thread: Re: Search and Index Question
- Next by thread: Re: Search and Index Question
- Index(es):
Relevant Pages
|
