InnoDB Fulltext search

Silverstripe Version: 3.1.21


Hi, after migrating a silverstripe database to Azure Msql server that only accept InnoDB engine a custom code I have to search for page content stop working.

Code Example

SQL Query to create indexes

If i run search code using one field it works, once I add 2 or more fields it stop working.

Any help will be appreciated.