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 Customer 
> WHERE MATCH (companyName, streetName, city, postalCode, lastName, firstName) 
> AGAINST ('Mark -Nijmegen' IN BOOLEAN MODE) 
> ORDER BY score DESC 
> 
> The only thing I changed is '-Nijmegen' in stead of '-Heesch'. Both values 
> are in the 'city' column of the table. '-Nijmegen' give's a resultset but the 
> result still contains value's with 'Nijmegen'. If I use '-Heesch' the 
> resultset doesn't have results containing 'Heesch'.
> 
> Strange huh?

Hm .. worked fine for me on my test table. Could you create repeateable test case?




-- 
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]

Reply via email to