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] -~----------~----~----~----~------~----~------~--~---
