MySQL Forums
Forum List  »  Full-Text Search

Re: FULLTEXT Indexing
Posted by: Zhiliang Hu
Date: May 12, 2005 11:11AM

I added FULLTEXT to my table using

> ALTER TABLE map_ref ADD FULLTEXT (Authors,Title,Keywords);

When I tried search, it reutrns nothing for many rare words I used:
select * from map_ref where MATCH (Authors,Title,Keywords) AGAINST ('some words');

Now I try to revert the table to using regular index, I found I don't have a name for my FULLTEXT index. Is that the cause for the null search problem?

How can I drop this FULLTEXT (without a name) and make a new one (with a name)?

Thanks in advance!


Options: ReplyQuote

Written By
April 20, 2005 10:37PM
April 21, 2005 06:40AM
May 02, 2005 04:51AM
Re: FULLTEXT Indexing
May 12, 2005 11:11AM
July 28, 2005 07:21PM

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.