1. The name field is used to store the customer’s name. The query results need to be sorted by the phonetic alphabet of the last name. Now there is a problem.
Names include both Chinese and English names, such as Zhang San, Li si, Jaewon Park and Lao Wang
In this way, the English name will always come first
I used the following sentence for sorting
NameUSING gbk ) COLLATE gbk_chinese_ci
How can the first letter of English be sorted by Pinyin?
Only use mysql to solve, Chinese and English mixed according to A-Z order, I have no way
One of my small thoughts is to add a column, convert Chinese into pinyin, and then sort by letter.