In Mysql, convert a field from Chinese to pinyin and take its initial statement to share _ MySQL

In Mysql, convert a field from Chinese to pinyin and use its initial statement to share bitsCN.com
In Mysql, the field is converted to Chinese pinyin, and the first letter of the field is used to share the Select t. id, t. ness_name, ELT (INTERVAL (CONV (HEX (left (CONVERT (t. ness_name USING gbk), 1), 16, 10), hour, hour, 0xB2C1, hour, hour, 0xB7A2, 0xB8C1, 0xB9FE, 0xBBF7, 0xBFA6, 0xC0AC, 0xC2E8, 0xC4C3, 0xC5B6, 0xC5BE, 0xC6DA, 0xC8BB, 0xC8F6, 0 xCBFA, 0 xCDDA, 0xCEF4, 0xD1B9, 0xD4D1), 'A', 'B', 'C', 'D ', 'E', 'F', 'G', 'H', 'J', 'K', 'L', 'M', 'n', 'O ', 'P', 'Q', 'R', 'S', 'T', 'W', 'X', 'y', 'z ') as py from msp_illness t order by t. id bitsCN.com