List:General Discussion« Previous MessageNext Message »
From:Timothy Little Date:December 2 2008 8:48pm
Subject:[Q] FULLTEXT index question
View as plain text  
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...
Thread
Stopping using a server as a slaveJesse25 Nov
  • Re: Stopping using a server as a slaveAmit Sharma25 Nov
  • Re: Stopping using a server as a slaveKrishna Chandra Prajapati26 Nov
    • Re: Stopping using a server as a slaveClaudio Nanni26 Nov
      • RE: Stopping using a server as a slaveRolando Edwards26 Nov
      • [Q] FULLTEXT index questionTimothy Little2 Dec
        • create single resultset from multiple setsBryan Cantwell2 Dec
          • Re: create single resultset from multiple setsAndy Shellam2 Dec