随笔分类 -  MySQL

SQL如何让中文名字按 名字第一个字的拼音首字母排序
摘要：select isnull(b.py,upper(left(a.username,1))) as py, a.username from ( select 'a3' as username union select '中华人民共和国' union select '周笔畅' union select '郭安俊' union select '天堂' union select ... 阅读全文
posted @ 2007-12-17 16:11 元宵子 阅读(2240) 评论(0) 推荐(0)