Thanks for the suggestions. Will have to play around with this a bit and see which works best in our situation. I'm somewhat tempted to switch over to Lucene eventually as I am more familiar with that. However, MySQL's full text search seems to work pretty well. Thanks again!
David On Jun 27, 11:12 pm, Steve Wake <[email protected]> wrote: > Also, if you use boolean mode, it helps to prepend all words with a + > (including the first) or it can use the first as an 'or'. > > On 26/06/2009, at 9:59 AM, Matias Gertel wrote: > > > > > Hi David, > > You may want to try the "IN BOOLEAN MODE" modifier. If you prepend > > the short words and/or stopwords with a + mysql will still search > > for them. It works differently than the regular fulltext search, so > > you'll have to play with it to make sure the results are still > > relevant. > >http://dev.mysql.com/doc/refman/5.1/en/fulltext-boolean.html > > > Matias Gertel > > Freelance Web Development & Coding > > e: [email protected] > > m: +64 21 288 8840 > > p: +64 9 838 3367 > > > On 26/06/2009, at 7:30 AM, Berend de Boer wrote: > > >>>>>> "David" == David <[email protected]> writes: > > > David> Perhaps I should allow 2-3 character terms and just parse > > David> out stop words, but this may be an overly complex solution > > David> to a simple problem. > > > MySQL has a list of stop words I believe. I remember vaguely it is > > hard to change, but I'm always on 3 character words, and this doesn't > > appear to be a problem. > > > -- > > Cheers, > > > Berend de Boer --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
