创建存储过程,将中文字段转拼音首字母
1 2 3 4 5 6 7 8 9 10 |
|
中文转拼音
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
|
select
upper(pinyin(user_name))
as
un,user_name
from
ecs_users
where
user_id=63 and upper(pinyin(user_name)) like
'%c%'
;