MySQL Forums
Forum List  »  Full-Text Search

Cannot search for the word "right"
Posted by: Stephen Hall
Date: October 09, 2005 01:56PM

Hello all,

Strange error that I can't seem to understand. I have created a table for items and a fulltext index on the column named "name" (for the item name). Below are the results on several searches:

mysql> select name, match(name) against ("study") from item;
+------------------------+-------------------------------+
| name | match(name) against ("study") |
+------------------------+-------------------------------+
| cdscas | 0 |
| qwe | 0 |
| ghj | 0 |
| Study Right Elementary | 1.0739123291942 |
+------------------------+-------------------------------+

mysql> select name, match(name) against ("right") from item;
+------------------------+-------------------------------+
| name | match(name) against ("right") |
+------------------------+-------------------------------+
| cdscas | 0 |
| qwe | 0 |
| ghj | 0 |
| Study Right Elementary | 0 |
+------------------------+-------------------------------+

mysql> select name, match(name) against ("elementary") from item;
+------------------------+------------------------------------+
| name | match(name) against ("elementary") |
+------------------------+------------------------------------+
| cdscas | 0 |
| qwe | 0 |
| ghj | 0 |
| Study Right Elementary | 1.0739123291942 |
+------------------------+------------------------------------+

Sorry for the crummy tables, I can't help it, this isn't fixed character font.....

Anyways, as you can see (hopefully), I have four items. The other three are trash to help prevent the 50% thing (stopword) from happening. The words "study" and "elementary" bring up the correct relevance, but "right" brings up zero. Anyone have a clue why this is happening?

Thank in advance,

Stephen

Options: ReplyQuote


Subject
Views
Written By
Posted
Cannot search for the word "right"
3138
October 09, 2005 01:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.