zackrspv wrote:
> On Mar 7, 5:39 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> 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.
>> jstuck...@attglobal.net
>> ==================
>
> Well, I can't change it on my host as i'm on a shared account. The
> host refuses to change it as well, they consider it a security risk,
> tho I do not see how. There has to be an alternate way to do this,
> such as using regular expressions, etc, but i'm not sure; how can I
> accomplish what I need?
>

Not easily, I'm afraid. You might be able to do it with a regex, but
I'm not good at regex's.

And I don't really blame your hosting company - it wouldn't be a
security risk, but searching on short words can load down the server.

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