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
