- Moderator
- #1
I have a web store, and I'd like to have a more robust search engine.
The current query passes a search string, such as "books", and the query does something like "Select * from table where description LIKE '%@Searchstring%'"
What I would *REALLY* like to do is a much more robust search, something that would allow me to put in a search phrase like this:
books -rowling (To do search for books, but exclude rowling)
books OR novels (or some such syntax, to do a search for either)
... of course, the cat's meow would be able to do something like:
books OR novels -rowling (look for books OR novels, but exclude hits with rowling)
.... so, any thoughts on how to do a nice, robust search as part of a stored procedure, where the search phrase is pretty much all that is passed?
Just my 2¢
"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."
--Greg
The current query passes a search string, such as "books", and the query does something like "Select * from table where description LIKE '%@Searchstring%'"
What I would *REALLY* like to do is a much more robust search, something that would allow me to put in a search phrase like this:
books -rowling (To do search for books, but exclude rowling)
books OR novels (or some such syntax, to do a search for either)
... of course, the cat's meow would be able to do something like:
books OR novels -rowling (look for books OR novels, but exclude hits with rowling)
.... so, any thoughts on how to do a nice, robust search as part of a stored procedure, where the search phrase is pretty much all that is passed?
Just my 2¢
"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."
--Greg
