 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / September 2007Search and Index Question
We need to index and search on "(specific text here)". How can we do a free text search using the above. full text index your table on the columns you wish to search and then do this select * from tablename where freetext(*,'"(specific text here)")  SignatureRelevantNoise.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 > We need to index and search on "(specific text here)". > > How can we do a free text search using the above. Try it and it returns rows that does NOT have the "(some text here)". It all rows that have "some text here" > full text index your table on the columns you wish to search and then do > this [quoted text clipped - 4 lines] >> >> How can we do a free text search using the above. I am sorry I misunderstood you question. Basically the brackets are not indexed and are ignored in searches. SignatureRelevantNoise.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 > Try it and it returns rows that does NOT have the "(some text here)". > [quoted text clipped - 8 lines] >>> >>> How can we do a free text search using the above. Is there anyway to index and search on the phrase with brackets? >I am sorry I misunderstood you question. Basically the brackets are not >indexed and are ignored in searches. [quoted text clipped - 11 lines] >>>> >>>> How can we do a free text search using the above. try this: select * from tablename where freetext(*,'"(specific text here)"') and charindex('"(specific text here)",MyColumn) >0 SignatureRelevantNoise.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 > Is there anyway to index and search on the phrase with brackets? > [quoted text clipped - 13 lines] >>>>> >>>>> How can we do a free text search using the above. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.