Request for fulltext search support


#1

I’d like to see FULLTEXT search capability, for queries like his example:
SELECT COUNT(*) FROM articles
WHERE MATCH (title,body)
AGAINST (‘database’ IN NATURAL LANGUAGE MODE);

Tried using ?filter=(MATCH (title,body) AGAINST (‘database’ IN NATURAL LANGUAGE MODE)), but it’s not supported.

Example from
http://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html

Use case: autocomplete in an app, where the table(s) to search contain many records.