标题：*
140 字

TAG标签：（用空格隔开）
30 字

恢复历史版本：

HTML转MD HTML转MD2

1，简单方法<p style="border: 0px; margin-top: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: " helvetica="" pingfang="" hiragino="" sans="" microsoft="" noto="" cjk="" wenquanyi="" micro="" color:="" white-space:="" background-color:="">如果字符集采用的是 gbk(汉字编码字符集)，直接在查询语句后边添加 ORDER BY： SELECT * FROM table ORDER BY title;如果字符集采用的是 utf8(万国码)，需要先对字段进行转码然后排序：SELECT * FROM table ORDER BY CONVERT(title using gbk); 2.连表查询&nbsp; &nbsp;好处可以得到属于哪个字母 CREATE TABLE IF NOT EXISTS `letter` (	`letter` 			char(1) NOT NULL 									COMMENT &#39;ID&#39;,	`begin` 			int(11) unsigned NOT NULL DEFAULT &#39;0&#39; 				COMMENT &#39;&#39;,	`end` 				int(11) unsigned NOT NULL DEFAULT &#39;0&#39; 				COMMENT &#39;&#39;,		PRIMARY KEY (`letter`)) ENGINE=InnoDB&nbsp; DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT=&#39;&#39;; INSERT INTO `letter` VALUES (&#39;A&#39;, 45217, 45252);INSERT INTO `letter` VALUES (&#39;B&#39;, 45253, 45760);INSERT INTO `letter` VALUES (&#39;C&#39;, 45761, 46317);INSERT INTO `letter` VALUES (&#39;D&#39;, 46318, 46825);INSERT INTO `letter` VALUES (&#39;E&#39;, 46826, 47009);INSERT INTO `letter` VALUES (&#39;F&#39;, 47010, 47296);INSERT INTO `letter` VALUES (&#39;G&#39;, 47297, 47613);INSERT INTO `letter` VALUES (&#39;H&#39;, 47614, 48118);INSERT INTO `letter` VALUES (&#39;J&#39;, 48119, 49061);INSERT INTO `letter` VALUES (&#39;K&#39;, 49062, 49323);INSERT INTO `letter` VALUES (&#39;L&#39;, 49324, 49895);INSERT INTO `letter` VALUES (&#39;M&#39;, 49896, 50370);INSERT INTO `letter` VALUES (&#39;N&#39;, 50371, 50613);INSERT INTO `letter` VALUES (&#39;O&#39;, 50614, 50621);INSERT INTO `letter` VALUES (&#39;P&#39;, 50622, 50905);INSERT INTO `letter` VALUES (&#39;Q&#39;, 50906, 51386);INSERT INTO `letter` VALUES (&#39;R&#39;, 51387, 51445);INSERT INTO `letter` VALUES (&#39;S&#39;, 51446, 52217);INSERT INTO `letter` VALUES (&#39;T&#39;, 52218, 52697);INSERT INTO `letter` VALUES (&#39;W&#39;, 52698, 52979);INSERT INTO `letter` VALUES (&#39;X&#39;, 52980, 53640);INSERT INTO `letter` VALUES (&#39;Y&#39;, 53689, 54480);INSERT INTO `letter` VALUES (&#39;Z&#39;, 54481, 55289); &nbsp; SELECT * FROM `je_region` a left join `letter` b on CONV(HEX(left(CONVERT(a.region_name using gbk),1)),16,10) between b.begin and b.end where region_type=2 order by b.letter&nbsp; limit 600 SELECT * FROM `je_region` a left join `letter` b on CONV(HEX(left(CONVERT(a.region_name using gbk),1)),16,10) between b.begin and b.end where region_type=2 order by CONVERT(a.region_name using gbk) limit 600 &nbsp; CONV(HEX(left(s.softName,1)),16,10) between c.cBegin and c.cEnd //把字母表左联&nbsp; 按要找的字段&nbsp; &nbsp; 排序按CONVERT(a.region_name using gbk)才准确&nbsp; &nbsp; 有些汉字没在字母表内