RE: [PHP] search string / query format

> -Original Message- > > I'm going to create a search page that accepts input similar to places > like > > Yahoo and Google. > [snip] > > Also, I've heard that MySQL's indexing can > > support some of this, but I'm not sure how much. > > Using a FULLTEXT index and searching in BOOLEAN m

Re: [PHP] search string / query format

>>Keyword AND keyword2 >>"keyword keyword2" -keyword3 It doesn't support AND or OR but it does use - + * and others. >Consult thine manual!! (The MySQL one) ;) http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html The problem is getting a FULLTEXT to sort by relevancy. This was a real pain, un

Re: [PHP] search string / query format

Ed Lazor wrote: I'm going to create a search page that accepts input similar to places like Yahoo and Google. [snip] > Also, I've heard that MySQL's indexing can support some of this, but I'm not sure how much. Using a FULLTEXT index and searching in BOOLEAN mode supports the type of search stri