Hi, I have installed mysql max 4.0.7 gamma on a Suse (ver. 8.0 professional) linux server. I have tried many full text queries and I had only a problem with a query like this:
SELECT count(a.rsori) pippo FROM ecoras a, ecotxt b WHERE MATCH ( b.rstxt ) AGAINST ( '-linux' IN BOOLEAN MODE ) AND a.rsori = b.rsori AND a.rscod = b.rscod; If I use only the minus operator I have not a valid resultset. If I use the minus operator with another one I have a reultset. For example: SELECT count(a.rsori) pippo FROM ecoras a, ecotxt b WHERE MATCH ( b.rstxt ) AGAINST ( '+linux -windows' IN BOOLEAN MODE ) AND a.rsori = b.rsori AND a.rscod = b.rscod; Is it a full text limit? Thanks Walter Procopio --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php