select * from users where signup_date between '2020-05-01' and '2020-12-10 23:59:59'; // Important with the times, // otherwize you will not get all records from end date. // Event if you only have date and no times in signup_date column