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!

Zhiliang

Options: ReplyQuote


Subject
Views
Written By
Posted
4193
April 20, 2005 10:37PM
2722
April 21, 2005 06:40AM
2524
May 02, 2005 04:51AM
Re: FULLTEXT Indexing
2998
May 12, 2005 11:11AM
2710
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.