Greetings all MySQL DBA,

I index my callno fields for fast search. When i did BETWEEN statement , it turned to slow down the query, and from the explain statement

explain select * from raw where callnobetween 71016800690001 and 71016800690100
id,select_type,table,type,possible_keys,key,key_le n,ref,rows,Extra
1,SIMPLE,raw,ALL,PRIMARY,,,,17478015,Using where
How do i improved my indexing.

Thank you