View Single Post

   
  #4 (permalink)  
Old 03-09-2008, 02:37 PM
Hoss
 
Posts: n/a
Default Re: Full Text Searching Help

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'
Reply With Quote