MySQL Forums
Forum List  »  Full-Text Search

Trouble with full-text search.
Posted by: massimo cordisco
Date: November 02, 2006 05:29AM

I've a trouble with full-text search.
I've created a full-text index composed by four fields :
TITLE_CONTENT,KEYWORDS_CONTENT,DESCRIPTION_CONTENT,PAGE_CONTENT.
In the field PAGE_CONTENT is present the word >>manga<<, so, i try to execute a query here reported,but the response is zero rows....
How is it possible?
And this happen not only for this key but for others too.

this is the query:

SELECT *, MATCH(TITLE_CONTENT,KEYWORDS_CONTENT,DESCRIPTION_CONTENT,PAGE_CONTENT) AGAINST('manga') AS attinenza FROM tabella WHERE MATCH(TITLE_CONTENT,KEYWORDS_CONTENT,DESCRIPTION_CONTENT,PAGE_CONTENT) AGAINST('manga')


Could someone help me??

thank.

Max.

Options: ReplyQuote


Subject
Views
Written By
Posted
Trouble with full-text search.
3545
November 02, 2006 05:29AM
2397
November 03, 2006 07:49AM


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.