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
Environment:
MySQL Version 3.23.42
FreeBSD 4.4
ISAM table of about 300,000 rows and 10 columns
with a column structured as varchar(50) upon which
exists a FULLTEXT index
Behavior:
The query
select * from tablename where match(column_name)
against('tree');
selects seven records.
The
Hi!
On Apr 15, Nicholas Murphy wrote:
The query
select * from tablename where match(column_name)
against('three');
fails to match any record.
Ten to twelve records in the table are know to have
the distinct word three in them in the indexed column.
Question:
Is this in any