Can one make a composite index with FULLTEXT for one column and standard
indexing on another?

For instance we have a table 
CREATE TABLE OurData 
(
   TheText       TEXT,
   TheLanguageID INTEGER
);

We have a FULLTEXT index on TheText, but want to be able to do searches
on TheText AND TheLanguageID.

So, an index like ( FULLTEXT TheText, TheLanguageID ) would be nice.

Is this possible?

Tim...

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to