Редактирование: MySQL (раздел)

===== DATEDIFF(), NOW() =====

Okay, so now you know how to select people who joined after a constant date. But what about if you want to only select people who joined in the last 7 days? The date keeps changing all the time, the date in the select statement, however, remains the same. The fix is pretty easy:

SELECT *<br>
FROM ss13_player<br>
WHERE DATEDIFF(Now(),firstseen) < 7

This will select everyone who joined 7 or fewer days ago.