或
select * from table_name where time between '2010-1-1' and '2010-5-1'

thinkphp中可用语句

$condition['id'] = array(between,array('1','8'));

查询 where('id' between '1' AND '8')