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, > > 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.
Could you provide query that gives you wrong result? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]