您将需要使用 * 来搜索部分单词:

You will need to use * to search partial words:

..
AGAINST('+dubai* +rit*' IN BOOLEAN MODE )

您可以在用于查询 MySql 的任何编程语言中的每个单词中添加 *.

You can add * to every word from whatever programming language you're using to query MySql.

PS:MySql 只允许前缀，即只能在字尾加*.

PS: MySql only allows prefix, means you can only add * at the end of the word.

参考:部分 *