select * from tabella
where '2007-09-25'
between data_inizio and data_fine