Full Text Searching Help 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? |