SELECT MySQL rows where today's date is between two DATE columns

Question

How can I get the rows in a table where today's date is between (inclusive) two DATE columns of that row? For example, take these two columns of a table:

How could I get the first and second rows on the 10th of April, or the 3rd row on the 25th (inclusive, like I said)?

Any help would be greatly appreciated. Thanks in advance!

Answer 1

You can add a condition as follows

DATE(NOW()) between date1 and date2