Cannot search for the word "right"
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
Subject
Views
Written By
Posted
Cannot search for the word "right"
3138
October 09, 2005 01:56PM
2186
October 09, 2005 01:58PM
2138
June 24, 2006 04:19AM
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.