List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 2 2002 2:28am
Subject:Re: full-text search (not in boolean mode)
View as plain text  
At 21:45 +0100 11/1/02, ddd wrote:
>hello
>
>i'm using mysql 3.23.41
>
>i want to search in fulltext indexed table for word "Down-Syndrom" but the
>result is the same like when I search "138721-Syndrom"..
>WHY ????

"-" isn't considered part of a word so you're really searching for
"down" or "syndrom" in the one case and "138721" or "syndrom" in the
other.  Both searches will match records that contain "syndrom".

>
>thanks
>
>SQL command:
>
>select IDpage, URL from news where match Words against ("Down-Syndrom");

Thread
MySQL Cookbook has been releasedPaul DuBois1 Nov
  • full-text search (not in boolean mode)ddd1 Nov
    • Re: full-text search (not in boolean mode)Paul DuBois2 Nov
  • Re: full-text search (not in boolean mode)ddd2 Nov
    • Re: full-text search (not in boolean mode)Paul DuBois2 Nov
      • Newbie question: Storing textPaul2 Nov
        • re: Newbie question: Storing textEgor Egorov4 Nov
          • re: Newbie question: Storing textPaul DuBois4 Nov
  • Replication and temp tables...Jon Frisby7 Nov
Re: Newbie question: Storing textWalter Lee Davis2 Nov
Re: Replication and temp tables...Heikki Tuuri8 Nov
  • RE: Replication and temp tables...Jon Frisby8 Nov
    • Re: Replication and temp tables...Heikki Tuuri8 Nov
Re: Replication and temp tables...Heikki Tuuri8 Nov