Select only month from timestamp in mysql query to archive articles by month

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Select only month from timestamp in mysql query to archive articles by month

Hi. I am a beginner in MySQL and have a question. I've used the same code to return all rows in the database table. Now I want to specify criteria for the date column (timestamp) to only return articles in that specified month.

Select only month from timestamp in mysql query to archive articles by month

I know that's where my problem is as stated in the previous post. I would someone to help me figure out what to put there. I've been working on this for a couple of days before I resorted to coming here and asking for help. If anybody could give me an example of what to put there, please help. Thanks in advance.