SELECTing rows by date as timestamp

1

Hello there!

I have been using placing date in my database as timestamps in an int type column.

I would like to select posts from a table by the year and then by the month given.

For example,
I would like to select rows inserted in the year 2007 and in January.

Now using FROM_UNIXTIME I could order the posts by year and month but now im not too sure what to do just to get certain posts

Here is what I uesd to sort the row:

SELECT id, dateSubmit FROM news WHERE FROM_UNIXTIME(dateSubmit)='YEAR(FROM_UNIXTIME($year)

Any ideas?

Paul