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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
