[sql] jak wyswietlic rekord Opcje

[rossco]

Chce wyswietlac z tabeli rekordy z ostatniego tygodnia. Jak powinno wygladac zapytanie SQL?

[nospor]

Wbrew pozorom manual nie gryzie:
http://dev.mysql.com/doc/refman/5.0/en/dat...-functions.html
(IMG:http://forum.php.pl/style_emoticons/default/smile.gif)

Here is an example that uses date functions. The following query selects all rows with a date_col value from within the last 30 days:

mysql> SELECT something FROM tbl_name
-> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;