How to select UNIX date = “2010” in mysql query?

Вот мой код на данный момент:

SELECT `date`, title, category, url
FROM cute_news
WHERE category = '4'
ORDER BY `date` DESC

Я хочу создавать страницы на основе года, например, 2010, 2009, 2008 и так далее. The database saves the date as UNIX_Timestamp. Not sure how to query a recordset with a Year parameter?

WHERE unix_timestamp(YEAR) = '2010' or something???

Thanks in advance. I'm baffled.

5
задан eberswine 25 October 2010 в 16:25
поделиться