scusa..te l'ho scritta male

SELECT * FROM tabella WHERE data BETWEEN date_start AND date_end;

ciao