Re: Problems with fulltext search in boolean mode

2004-01-09 Thread Egor Egorov
Mark van Herpen <[EMAIL PROTECTED]> wrote: > Sure, > > SELECT ID, companyName, streetName, houseNo, postalCode, city, firstName, > lastName, debNo, houseNoExt , MATCH (companyName, streetName, city, > postalCode, lastName, firstName) AGAINST ('Mark -Nijmegen' IN BOOLEAN MODE) > AS score > FRO

Re: Problems with fulltext search in boolean mode

2004-01-08 Thread Mark van Herpen
Sure, SELECT ID, companyName, streetName, houseNo, postalCode, city, firstName, lastName, debNo, houseNoExt , MATCH (companyName, streetName, city, postalCode, lastName, firstName) AGAINST ('Mark -Nijmegen' IN BOOLEAN MODE) AS score FROM Customer WHERE MATCH (companyName, streetName, city, p

Re: Problems with fulltext search in boolean mode

2004-01-08 Thread Egor Egorov
Mark van Herpen <[EMAIL PROTECTED]> wrote: > I've having some strange problems with a fulltext search in boolean mode. The > '-' operator doesn't seems to work correctly. First let me show you my query: > > SELECT ID, companyName, streetName, houseNo, postalCode, city, firstName, >