... WHERE campo_data BETWEEN ... AND ...

http://dev.mysql.com/doc/refman/5.0/...nction_between