clear markdown compare help best fiddles feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601453 fiddles created (47970 in the last week).

CREATE TABLE demo( evento INT, fecha1 DATETIME, fecha2 DATETIME );
 hidden batch(es)


INSERT INTO demo(evento, fecha1, fecha2) VALUES (1, "2019-06-11 10:00:00", "2019-06-11 12:00:00"), (2, "2019-06-11 13:00:00", "2019-06-11 15:00:00"), (3, "2019-06-12 08:00:00", "2019-06-12 10:00:00"), (4, "2019-06-13 08:00:00", "2019-06-13 10:00:00");
 hidden batch(es)


SELECT * FROM demo WHERE DATE(CURRENT_DATE() - INTERVAL 1 DAY) BETWEEN DATE(fecha1) AND DATE(fecha2);
evento fecha1 fecha2
1 2019-06-11 10:00:00 2019-06-11 12:00:00
2 2019-06-11 13:00:00 2019-06-11 15:00:00
 hidden batch(es)