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, streetName, city,
postalCode, lastName, firstName) AGAINST ('Mark -Heesch' IN BOOLEAN MODE) AS
score
FROM Customer
WHERE MATCH (companyName, streetName, city, postalCode, lastName, firstName)
AGAINST ('Mark -Heesch' IN BOOLEAN MODE)
ORDER BY score DESC
This returns al the records containing 'Mark' in the fulltext index without
'heesch' in the index. This works correctly, but when I use some other values
in stead of 'Heesch' the resultset still contains records with that value.
This also happens with other fields and other value's. With some value's it
works correctly, with others it doesn't. How is this possible?
I'm using MySQL 4.0.17 on a redhat linux machine, MySQL is standard
configured.
Mark van Herpen <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
