Mit MYSQL "gestern auswählen"

[Rainer]

Hi Philipp,

hab's so gemacht:

SELECT
    date_time,
    DAYOFMONTH(date_time) as tag,
    MONTH(date_time) as monat,
    YEAR(date_time) as jahr,
    HOUR(date_time) as stunde,
    count(site_name) as anzahl,
    DATE_SUB(NOW(), INTERVAL 1 DAY) as gestern
FROM
    tmp
WHERE
    tag = gestern
GROUP BY
    stunde
ORDER BY
    date_time DESC

Leider klappts nicht ...

Rainer