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?