I wrote data to the 'date' field with the mysql NOW () function. I want to SELECT the data that was recorded the last three days (today, yesterday and the day before yesterday), but do not intend to do this. I am trying my code as it should, please help.
SELECT * FROM tlb_students WHERE date ...? ... ORDER BY date DESC LIMIT 20
source share