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
4110
April 20, 2005 10:37PM
2689
April 21, 2005 06:40AM
2488
May 02, 2005 04:51AM
Re: FULLTEXT Indexing
2949
May 12, 2005 11:11AM
2674
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.