FULLTEXT on multiple columns not working

[beedie]

i have a query that works on two fulltext columns if only requesting one.

If I query both in the same query I get

Can't find FULLTEXT index matching the column list

 

$query ="SELECT * FROM reviews WHERE MATCH(company,experience) AGAINST ('yeah')";

but this is fine

$query ="SELECT * FROM reviews WHERE MATCH(company) AGAINST ('yeah')";

as is this:

$query ="SELECT * FROM reviews WHERE MATCH(experience) AGAINST ('yeah')";

 

Both columns have fulltext

 

FULLTEXT KEY `company` (`company`),
  FULLTEXT KEY `experience` (`experience`)

What is wrong?

 

[beedie]

When I added IN BOOLEAN MODE it worked.

$query ="SELECT * FROM reviews WHERE MATCH (company,experience) AGAINST ('yeah' IN BOOLEAN MODE)";

Now I'd like to know why if any one knows?

[fenway]

I'm confused... if you have it spanning two columns, you always need to refer to those.

[beedie]

Fenway I'm not sure what is confusing you.

I have two columns in the same table.

The search only works when I do the query on each one on it's own (except when I add the IN BOOLEAN MODE)

I thought I could do it without boolean mode for both columns in the same query. ??

[fenway]

The search only works when I do the query on each one on it's own (except when I add the IN BOOLEAN MODE)

It shouldn't work -- you have 2 separate indexes, so it requires searches on each one independently.  You're telling me you don't have an index that spans both columns?  Maybe it combines them now? Which version?