MySQL Forums
Forum List  »  Full-Text Search

Would appreciate if it was possible to combine a fulltext index with some other field
Posted by: Tore Krudtaa
Date: December 29, 2005 11:32AM

Okay... I know InnoDB does not support fulltext index today...
but according to www.innodb.com they are trying to implement fulltext index in 2006.

So here we go.......

First out:

Example:

Let say we have many customers in same table in an MyISAM table.

CusID
CusTextID
CusText

And we have a fulltext index on the CusText field.

Now.... if an end user wants to search using the fulltext index for customer where CusID=1.... MySql are using the indexed data from all the customers, not only for those records where CusID=1.

Would be cool if.... when fulltext index comes to InnoDB that it was possible to index as it is today in MyISAM but also using another field (or fields) together with the strings from the CustText field to build the index....in order to tell MySql that when searching using the fulltext index it should only search through the related index records for customer 1.......

So if possible. it would be nice if a fulltext index (the upcoming one for InnoDB) could either work as it works for MyISAM today, or as described above or possible to use both.......

Regards

Options: ReplyQuote


Subject
Views
Written By
Posted
Would appreciate if it was possible to combine a fulltext index with some other field
2935
December 29, 2005 11:32AM


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.