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

=== Combining column and row filtering ===

Easy:

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

Does the same as the statement a few lines above, but also filters columns. Note that you don't have to select all the columns you use in your where section. For example, even if you are not returning 'firstseen', but are using it in the WHERE section, this will still work:

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