Doctrine fulltext on multiple field

Viewed 1290

I've got an entity with some attributes and I want to index some of them for fulltext.

* @Index(name="search", columns={"description", "short_description", "name"}, flags={"fulltext"})})

Now if I execute a query using MATCH(description, short_description) AGAINST (...) I get:

Can't find FULLTEXT index matching the column list

If I index for fulltext only one column:

 * @Index(columns={"description"}, flags={"fulltext"})})

And then try to use MATCH(description) AGAINST (...) all works right.
So how can I index multiple columns?

Thanks.

2 Answers
Related