zackrspv 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?
>

From the MySQL manual under full text searches:

"Any word that is too short is ignored. The default minimum length of
words that are found by full-text searches is four characters"

RSI is, of course, shorter than that.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================