List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 2 2002 1:58pm
Subject:Re: full-text search (not in boolean mode)
View as plain text  
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 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");
>>
>>
>>
>>.
>>
>
>
>
>---------------------------------------------------------------------
>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 <mysql-thread123858@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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