MySQL full text search in Backand

Question

I'm using Backand as my backend as a service and I'm trying to find a way to add MySQL full-text search in my App.

Can anyone help me how to do it?

Thanks.

Answer 1

In Backand query you can use any MySQL syntax, so just add input parameter (MyText) as the text to be searched on and use this query:

SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('{{MyText}}' WITH QUERY EXPANSION);