| 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 slave | Jesse | 25 Nov |
| • Re: Stopping using a server as a slave | Amit Sharma | 25 Nov |
| • Re: Stopping using a server as a slave | Krishna Chandra Prajapati | 26 Nov |
| • Re: Stopping using a server as a slave | Claudio Nanni | 26 Nov |
| • RE: Stopping using a server as a slave | Rolando Edwards | 26 Nov |
| • [Q] FULLTEXT index question | Timothy Little | 2 Dec |
| • create single resultset from multiple sets | Bryan Cantwell | 2 Dec |
| • Re: create single resultset from multiple sets | Andy Shellam | 2 Dec |
