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.