A commodity information table, in order to facilitate the search, need to build two full and first spelling fields?

A commodity information table, in order to facilitate the search, need to build two full and first spelling fields?

For example:
Product Name: Package Dish
Full spell: Baocai
First spell: BC

Do you need this?

Reply content:

A commodity information table, in order to facilitate the search, need to build two full and first spelling fields?

For example:
Product Name: Package Dish
Full spell: Baocai
First spell: BC

Do you need this?

Can be built, but AutoComplete, certainly not through the MySQL like to check, backstage or through the search engine (such as Sphinx) to the two words Jianjian index

Search can be directly used in Chinese keywords, here is not a big relationship, and you mentioned this problem in SEO. The Chinese in this place will not have an impact on SEO.
In fact, SEO for these details are tending to humanization, such as Baidu tends to Chinese details as well as pinyin, and Google tends to semantic words.
If you need to use a phonetic search in your search. Then you mentioned that it is necessary to create a new data column. Otherwise, there is no need.

Does anyone know?

