Re: full-text search (not in boolean mode)

2002-11-02 Thread Paul DuBois
At 13:29 +0100 11/2/02, ddd wrote: i know ! That wasn't apparent from your message. but how to solve it ??! can anybody help how to search word with "-" Use a phrase search in boolean mode, which requires the original phrase exactly as present in the table. thanx Paul DuBois wrote: At

Re: full-text search (not in boolean mode)

2002-11-02 Thread ddd
i know ! but how to solve it ??! can anybody help how to search word with "-" thanx Paul DuBois wrote: 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-

Re: full-text search (not in boolean mode)

2002-11-01 Thread Paul DuBois
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" i

full-text search (not in boolean mode)

2002-11-01 Thread ddd
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 thanks SQL command: select IDpage, URL from news where match Words against ("Down-Syndrom");