How to get list of records between dates using mysql?
Just use this sql code for your requests and you will get records included into period between these dates (including start and end dates):
SELECT * FROM events WHERE event_date BETWEEN DATE("2023-01-01") AND DATE("2023-01-31");That's all