Re: fulltext phrase search

2002-08-09 Thread Sergei Golubchik
Hi! On Aug 08, Dan Nelson wrote: > In the last episode (Aug 08), Christopher Book said: > > Using mysql 4.0.2 I get the following behaviour (phrase searching): > > > > match (field) against ('"pack of"' in boolean mode) > > > > gives me all results with 'pack of', not just 'pack'. So MySQL

Re: fulltext phrase search

2002-08-08 Thread Dan Nelson
In the last episode (Aug 08), Christopher Book said: > Using mysql 4.0.2 I get the following behaviour (phrase searching): > > match (field) against ('"pack of"' in boolean mode) > > gives me all results with 'pack of', not just 'pack'. So MySQL isn't > ignoring 'of' even though the word is

fulltext phrase search

2002-08-08 Thread Christopher Book
Hi, Using mysql 4.0.2 I get the following behaviour (phrase searching): match (field) against ('"pack of"' in boolean mode) gives me all results with 'pack of', not just 'pack'. So MySQL isn't ignoring 'of' even though the word is too short to normally be considered. However if I use: matc