Answers for "mysql last 10 days"

mysql last 7 days including today

SELECT * FROM `account` 
WHERE DATE(created_at) > (NOW() - INTERVAL 7 DAY)

Posted by: Guest on July-26-2021

mysql select last 10 rows

SELECT * FROM tableName ORDER BY col1 DESC LIMIT 10;

Posted by: Guest on August-13-2021

Code answers related to "mysql last 10 days"