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
FROM
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,
lastName, debNo, houseNoExt , MATCH (companyName,
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,
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,