Would appreciate if it was possible to combine a fulltext index with some other field
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
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.