Getting context of search results

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mr. Roundhill - 14 Oct 2005 21:52 GMT

Anyone know how to get the context of the search results in a full text
query? I'm trying to get similar results to the popular seach engines where
it displays the link to the document, and underneath it it shows the context
of the search words in the context of the document. For example, searching
for SQL server on google:

SQL Server Home
Visit this portal for all the latest news and articles to help you evaluate
Microsoft SQL Server 2000 for your data management and analysis needs.

Thanks!

-- are we all computer monkeys?

Reply to this Message

Hilary Cotter - 15 Oct 2005 00:25 GMT

this is called hit highlighing.

Here is one way to do it - the least efficient way.

http://groups.google.com/group/microsoft.public.sqlserver.fulltext/msg/81eb71cac
37c6cf3?dmode=source

Signature

Hilary Cotter
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

> Anyone know how to get the context of the search results in a full text
> query? I'm trying to get similar results to the popular seach engines
[quoted text clipped - 13 lines]
>
> -- are we all computer monkeys?

Reply to this Message

John Kane - 15 Oct 2005 17:53 GMT

Mr. Roundhill,
Try the following SQL FTS query on the pubs table pub_info as the following
query will return rows that match the FTS search word (books) and the near
by words from 20 characters before the searched keyword (books) for a total
length of 100 characters.

SELECT pub_id, SubString(pr_info,PatIndex ('%books%',pr_info)-20,100)
FROM pub_info
WHERE Contains(pr_info, 'books')

Regards,
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

Reply to this Message

Mr. Roundhill - 14 Dec 2005 18:21 GMT

Thanks for the help! That seems to work just fine.

> Mr. Roundhill,
> Try the following SQL FTS query on the pubs table pub_info as the following
[quoted text clipped - 25 lines]
> >
> > -- are we all computer monkeys?

Reply to this Message