Se il formato e' yyyy-mm-dd

.... where CURDATE() BETWEEN data1 AND data2