On Mar 7, 12:15 pm, zackrspv <old...@gmail.com> wrote:
> So, I understand how to do it, and it works for the most part; for
> example if my code is:
>
> SELECT * FROM info WHERE MATCH(term) AGAINST ('relative')
>
> I get around 5 results, such as the following:
>
> Relative Strength
> Relative Return
> Price-Earnings Relative
> Relative Strength Index (RSI)
> Relative Vigor Index (RVI)
> Relative Purchase Power Parity
>
> But, let us assume that we are searching for 'RSI':
>
> SELECT * FROM info WHERE MATCH(term) AGAINST ('RSI')
>
> When we do that, boom, no results; yet we can clearly SEE that RSI
> does exist in the terms above.
>
> How can i get it to return the result?

Note, also, that I can use the following code as well and it works
fine:

SELECT * FROM info WHERE MATCH(term) AGAINST ('+RSI' IN BOOLEAN MODE)

But if i try and specify RSI in there:

Still, no results.

So, maybe i'm just confused on how to do it, or i just don't get it :/