sql语句，选出汉字的首字母
网上的代码建了一个pinyin表
CREATE TABLE `pinyin` (
`PY` varchar(1),
`HZ1` varchar(1),
`HZ2` varchar(1)
) ;

INSERT INTO `pinyin` (`PY`,`HZ1`,`HZ2`) VALUES
('A','吖',''),
('B','八','簿'),
('C','嚓',''),
('D','',''),
('E','',''),
('F','发',''),
('G','',''),
('H','',''),
('J','丌',''),
('K','咔',''),
('L','垃',''),
('M','',''),
('N','',''),
('O','噢',''),
('P','','曝'),
('Q','七',''),
('R','',''),
('S','仨',''),
('T','他',''),
('W','',''),
('X','夕',''),
('Y','丫',''),
('Z','','');
select * from pinyin where HZ1<='神马情况' and HZ2>='神马情况' 得到了一个好多列的表格..求教
按照网上那个运行应该得到('S','仨','') 这一列的内容呀。。。why
谢谢

[解决办法]
起码也得和表的字符集有关系吧

show create table pinyin;看下表的字符集是什么
[解决办法]
可以这样得到首字母拼音

SELECT top 1 *
from pinyin
where HZ1 <= SUBSTRING('神',len('神'),1)
ORDER BY PY DESC
[解决办法]
http://topic.csdn.net/u/20090611/17/7579bb9a-0a7c-4460-a302-10bae7f4a9c5.html?1526