For example, the best solution is under node:)
1. If it is java, we will use pinyin4j to preprocess the data to be retrieved and add a Pinyin field. For example, if hero is yx, then ordinary mysql fuzzy retrieval is sufficient.
Incidentally, in the address book of android phone inside, the alphabetical order also preprocesses the names first.