mysql 优化之 in between and

SELECT * FROM a
WHERE
id IN (1,2,3,4,5,6,7…..100)
这个这种sql 怎么优化

方法between and

select * from a where id >=1 and id <=100;

• 改为列名name
  *select name from a where id >=1 and id <=100;