I find doing this helps to reinitialize the indexes
ALTER TABLE shotlist TYPE=MyISAM;
REPAIR TABLE shotlist QUICK;
> I am trying to add a second fulltext index to an already existing table
> (named "articles").
>
> The first index is for field(column name) "text" of type "longtext"
>
> I want to add a second index that will be for this field and
> field(column name) "title" of type "varchar"
>
> I used this query: >alter table articles add fulltext (title,text);
>
> But after doing that, and getting a "query OK" result that indicated
> all existing rows had been affected, the fulltext index (title,text)
> does not work, because the rows supposedly indexed from the "title"
> column are not bringing up any results (for known-item searching).
>
> The query against this index was: >SELECT * FROM articles WHERE MATCH
> (title,text) AGAINST ('search_term');
>
> Am I missing something? Is the query I wrote above incorrect?
>
> Any help would be super appreciated.
>
> Thanks,
> Nathan
> --
> Nathan Mealey
> Director of Operations
> Cycle-Smart, Inc.
> P.O. Box 1482
> Northampton, MA
> 01061-1482
> [EMAIL PROTECTED]
> (413) 587-3133
> (413) 210-7984 Mobile
> (512) 681-7043 Fax
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
