Fulltext fields search — ONLY one keyword return none results

I am building search enhancement in Drupal 8 site. I have one search server: Acquia search API In the search API fields tab, i set up title, rendered HTML and taxonomy term as fulltext fields and boost them accordingly.

In my search view, i selected three of them as search fields and put the min keywords length as 1. view picture If i search two keywords, it works good like ‘ONE TWO’. If i only select ‘ONE’, it return none result.

The SQL query looks like the following: Query

Any suggestions will be appreciated.

Thanks.

MySQL – Boolean Full-text Search

I’m using MySQL’s boolean full-text search for my search engine: https://dev.mysql.com/doc/refman/5.6/en/fulltext-boolean.html.

Assume I have a table with the following columns:

PRODUCTS -------- id (PK) color_id (FK to COLORS table) name description 

When given a search term, I want to search the product’s table’s name and description columns, as well as the product’s color name. The color’s name is in a separate table.

Should I create a new column in the product’s table and put all the text I want indexed in there? For example, I add a products.full_text_index column, and dump a concatenation of name, description, and the color’s name in that column? Then do full-text search against that column?

UPDATE: Or, instead of a column in an existing table, maybe create a new table to contain all the text that should be used for the full-text search. That table can just have a FK to the products table.