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

Check the docs. That's the default; you can change it. I don't
remember the exact parm offhand - never had to change it, myself.

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