PHP/MYSQL实现按字母检索

方法一：建一个拼音表 t_cosler ，存放每个字母开头的第一个汉字的编号和最后一个汉字的编号。   
BatchFile code+------+--------+-------+  
| f_PY | cBegin | cEnd  |  
+------+--------+-------+  
| A    |  45217 | 45252 |  
| B    |  45253 | 45760 |  
.....  
| Z    |  54481 | 55289 |  
+------+--------+-------+  
 
 
然后直接查询就行了。   
 
SQL codemysql> create table t_cosler(  
    ->  f_PY char primary key,  
    ->  cBegin  SMALLINT UNSIGNED not null,  
    ->  cEnd    SMALLINT UNSIGNED not null  
    -> );  
Query OK, 0 rows affected (0.09 sec)  
 
mysql> insert into t_cosler values  
    -> ('A',0xB0A1,0xB0C4),  
    -> ('B',0xB0C5,0xB2C0),  
    -> ('C',0xB2C1,0xB4ED),  
    -> ('D',0xB4EE,0xB6E9),  
    -> ('E',0xB6EA,0xB7A1),  
    -> ('F',0xB7A2,0xB8C0),  
    -> ('G',0xB8C1,0xB9FD),  
    -> ('H',0xB9FE,0xBBF6),  
    -> ('J',0xBBF7,0xBFA5),  
    -> ('K',0xBFA6,0xC0AB),  
    -> ('L',0xC0AC,0xC2E7),  
    -> ('M',0xC2E8,0xC4C2),  
    -> ('N',0xC4C3,0xC5B5),  
    -> ('O',0xC5B6,0xC5BD),  
    -> ('P',0xC5BE,0xC6D9),  
    -> ('Q',0xC6DA,0xC8BA),  
    -> (