A product information table. Do I need to create two fields for full spelling and first spelling to facilitate search?

A product information table. Do I need to create two fields for full spelling and first spelling to facilitate search? For example: product name: cabbage full fight: baocai first fight: bc need this? A product information table. Do I need to create two fields for full spelling and first spelling to facilitate search?

For example:
Product Name: Cabbage
Full competition: baocai
First fight: bc

Do you need this?

Reply content:

A product information table. Do I need to create two fields for full spelling and first spelling to facilitate search?

For example:
Product Name: Cabbage
Full competition: baocai
First fight: bc

Do you need this?

Yes, but in autocomplete mode, we certainly didn't use mysql like to check the index. in the background, we still need to use a search engine (such as sphworkflow) to index the two fields.

You can directly use Chinese keywords for search. it is not relevant here, and you mentioned this issue in seo. The Chinese here will not affect seo.
In fact, seo tends to be user-friendly for these details. for example, Baidu tends to have Chinese details and pinyin, while Google tends to have semantic keywords.
If you need to use pinyin search in your search. It is necessary to create a data column. Otherwise, it is not required.

Does anyone know?