List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 8 2003 4:44pm
Subject:Re: Full text limitation?
View as plain text  
At 14:03 +0100 1/8/03, Walter Procopio wrote:
>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.

Isn't that the same as asking for records that don't match anything?

>  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

Thread
Full text limitation?Walter Procopio8 Jan
  • Re: Full text limitation?Paul DuBois8 Jan
  • Re: Full text limitation?Walter Procopio9 Jan
    • Re: Full text limitation?Sergei Golubchik10 Jan