On Mar 7, 3:22*pm, zackrspv <old...@gmail.com> wrote:
> > SELECT * FROM info WHERE MATCH(term) AGAINST ('+RSI' IN BOOLEAN MODE)
>
> Ooops, meant:
>
> SELECT * FROM info WHERE MATCH(term) AGAINST ('+relative +strength' IN
> BOOLEAN MODE)
>
> haha, of course i meant to say that the quote text above DIDN'T work
> lol sorry, i'm a bit tired i guess.
Two possible things to start. I don't remember how MySQL handles the
'(', but it is possible that it is looking for the 'word' 'RSI' and is
not matching it because it finds the 'word' '(RSI)'
The other, more likely explaination is that the minimum word length is
set to 4 characters, so it's just ignoring RSI.
Check out this link
http://dev.mysql.com/doc/refman/5.0/...ne-tuning.html
and look for 'ft_min_word_len'