On Mar 7, 2:09 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> 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.
> jstuck...@attglobal.net
> ==================

now see that just sucks; how can i get it to display the results if my
clients are searching for things like RSI, RVI, ESS, etc. Most of the
don't know what they mean, and the terms would still have to display
that. If i can't use a full text search, i'd use %like% but that'd be
pointless as it would return other things like 'RSI' for 'version' and
'conversion'.

Any ideas on a way to get around this?