Best way to do db search for site

[Guest]

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?

 

[Guest]

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]

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