Search is not giving proper result
Posted by:
development
Date: September 01, 2005 04:04AM
Dear all,
I am very new to mysql full-text search.
I am evaluating this feature for implementation of a search engine for our documents in database. We are using 'longtext' datatype for storing documents in table, with fulltext index.
I've created a temp table for testing
CREATE TBL_XX_TEST
(
FLD_ID INT,
FLD_DESC LONGTEXT,
FULLTEXT(FLD_DESC)
)
and the data is
FLD_ID | FLD_DESC
1 | This is AAA from XXX
2 | This is BBB from YYY
3 | This is CCC from ZZZ
now i m executing the query
SELECT * FROM TBL_RUSHIK_TEST
WHERE MATCH (FLD_DESC) AGAINST ('AAA'); -> gives me the 1st row
SELECT * FROM TBL_RUSHIK_TEST
WHERE MATCH (FLD_DESC) AGAINST ('This'); -> no result
Actually it should give me all the three rows. I m not able to identify what is the problem.
Please suggest me any solution for this.
Thanks
Rushik.
Subject
Views
Written By
Posted
Search is not giving proper result
3361
September 01, 2005 04:04AM
2279
September 06, 2005 03:07PM
2335
September 13, 2005 12:35PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.