Best way to do db search for site

[Michael]

Hi,
I have not implimented a search feature yet for a web site yet and wanted to
get some advice. Most of the search tips I have seen so far only deal with
searching html files or other web files. I don't need this type of search.
All I need to do is search the products tables (description and Name fields)
and return the results. Now, I could do a query like:
Select * from products where description like @SearchWord
But I'm not sure if that would be good anough to return the results needed.
What happens if the user uses more than one word in the search string? I
think the query would have to be expanded further to support more words.
Ok, Now to the main question. How well does the Full-Text search feature of
SQL Server work? How is the performance really. I've read that its suppose to
be fast, but most of that is from MS docs, and I just want to make sure what
experiances others have had.
What are you options on this topic. Thanks for any advice.
Michael Lee

[Jeff Dillon]

What IF the user searches for more than one word? What do you WANT to
happen? OR the words? AND the words?

"Michael" <Mi*****@discussions.microsoft.com> wrote in message
news:DA**********************************@microsof t.com...

Hi,
I have not implimented a search feature yet for a web site yet and wanted
to
get some advice. Most of the search tips I have seen so far only deal with
searching html files or other web files. I don't need this type of search.
All I need to do is search the products tables (description and Name
fields)
and return the results. Now, I could do a query like:
Select * from products where description like @SearchWord
But I'm not sure if that would be good anough to return the results
needed.
What happens if the user uses more than one word in the search string? I
think the query would have to be expanded further to support more words.
Ok, Now to the main question. How well does the Full-Text search feature
of
SQL Server work? How is the performance really. I've read that its suppose
to
be fast, but most of that is from MS docs, and I just want to make sure
what
experiances others have had.
What are you options on this topic. Thanks for any advice.
Michael Lee

[Michael]

Hi Jeff,
I have thought about that also and would like to cover that option also. I
know I'm always trying to use more than one word during website searchs and
noticed not all sites seem to work well. I seem to recall something about
Fulltext search supported boolean searchs (and, or, ect). If I have to, I
will write the code necessary support the boolean operation, but was hoping
that Fulltext search supported this. What do you think.
Thanks for the reply.
Michael
"Jeff Dillon" wrote:

What IF the user searches for more than one word? What do you WANT to
happen? OR the words? AND the words?

"Michael" <Mi*****@discussions.microsoft.com> wrote in message
news:DA**********************************@microsof t.com...

Hi,
I have not implimented a search feature yet for a web site yet and wanted
to
get some advice. Most of the search tips I have seen so far only deal with
searching html files or other web files. I don't need this type of search.
All I need to do is search the products tables (description and Name
fields)
and return the results. Now, I could do a query like:
Select * from products where description like @SearchWord
But I'm not sure if that would be good anough to return the results
needed.
What happens if the user uses more than one word in the search string? I
think the query would have to be expanded further to support more words.
Ok, Now to the main question. How well does the Full-Text search feature
of
SQL Server work? How is the performance really. I've read that its suppose
to
be fast, but most of that is from MS docs, and I just want to make sure
what
experiances others have had.
What are you options on this topic. Thanks for any advice.
Michael Lee

[Jeff Dillon]

First, you have to decide what you want (?) and set down some rules. If you
can't describe it in English, the technology won't help.

Yes, full text can do these things.

Jeff
"Michael" <Mi*****@discussions.microsoft.com> wrote in message
news:9C**********************************@microsof t.com...

Hi Jeff,
I have thought about that also and would like to cover that option also. I
know I'm always trying to use more than one word during website searchs
and
noticed not all sites seem to work well. I seem to recall something about
Fulltext search supported boolean searchs (and, or, ect). If I have to, I
will write the code necessary support the boolean operation, but was
hoping
that Fulltext search supported this. What do you think.
Thanks for the reply.
Michael
"Jeff Dillon" wrote:

What IF the user searches for more than one word? What do you WANT to
happen? OR the words? AND the words?

"Michael" <Mi*****@discussions.microsoft.com> wrote in message
news:DA**********************************@microsof t.com...

> Hi,
> I have not implimented a search feature yet for a web site yet and
> wanted
> to
> get some advice. Most of the search tips I have seen so far only deal
> with
> searching html files or other web files. I don't need this type of
> search.
> All I need to do is search the products tables (description and Name
> fields)
> and return the results. Now, I could do a query like:
> Select * from products where description like @SearchWord
> But I'm not sure if that would be good anough to return the results
> needed.
> What happens if the user uses more than one word in the search string?
> I
> think the query would have to be expanded further to support more
> words.
> Ok, Now to the main question. How well does the Full-Text search
> feature
> of
> SQL Server work? How is the performance really. I've read that its
> suppose
> to
> be fast, but most of that is from MS docs, and I just want to make sure
> what
> experiances others have had.
> What are you options on this topic. Thanks for any advice.
> Michael Lee