By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE my_table (
`ID` INTEGER,
`Date` DATE
);
INSERT INTO my_table
(`ID`, `Date`)
VALUES
('1', '2021-04-02'),
('2', '2020-04-13'),
('3', '2019-04-29'),
('4', '2018-04-30'),
('5', '2019-06-24');
Records: 5 Duplicates: 0 Warnings: 0
SELECT *
FROM my_table
WHERE MONTH(date) = MONTH(CURRENT_DATE)
AND YEAR(date) < YEAR(CURRENT_DATE)
AND DAY(date) < DAY(CURRENT_DATE);
| ID | Date |
|---|---|
| 1 | 2021-04-02 |