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]
