Home >Database >Mysql Tutorial >Mysql中字段汉语转换成拼音，并取其首字母语句分享_MySQL
Mysql中字段汉语转换成拼音，并取其首字母语句分享_MySQL
- WBOYOriginal
- 2016-06-01 13:40:271433browse
bitsCN.com
Mysql中字段汉语转换成拼音，并取其首字母语句分享 Select t.id,t.ness_name, ELT(INTERVAL(CONV(HEX(left(CONVERT(t.ness_name USING gbk),1)),16,10),0xB0A1,0xB0C5,0xB2C1,0xB4EE,0xB6EA,0xB7A2,0xB8C1,0xB9FE,0xBBF7, 0xBFA6,0xC0AC,0xC2E8,0xC4C3,0xC5B6,0xC5BE,0xC6DA,0xC8BB,0xC8F6,0xCBFA,0xCDDA,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
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：理解mysql锁（1）锁的概述_MySQLNext article：mysql日期比较语句_MySQL