据汉语首字母分组

排序

select areaName from area order by convert(areaName USING gbk) COLLATE gbk_chinese_ci asc

分组排序

$sql = "Select id,cat_name ,ELT(INTERVAL(CONV(HEX(left(CONVERT(cat_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 seg_shop_county where deep_id=2  ORDER BY CONVERT( cat_name USING gbk ) COLLATE gbk_chinese_ci ASC";
发布了24 篇原创文章 · 获赞 0 · 访问量 209
展开阅读全文

没有更多推荐了,返回首页

©️2019 CSDN 皮肤主题: 深蓝海洋 设计师: CSDN官方博客

分享到微信朋友圈

×

扫一扫,手机浏览