Retrieve mySQL record based on partial string

Could anybody offer any explanation as to how I could retrieve records based on a certain month.

The datefield I have to work with, is in the following format 2004-04-28.

I have split the string and been using the following characters to try and retrieve the records 2004-04 using the following syntax

SELECT newsId, published, subject FROM news WHERE published LIKE 2004-04 ORDER BY published DESC.

This retrieves all the records in the database.

Thanks inadvance.

Look up the month() function in the mysql manual.

SELECT fields
FROM table
WHERE month(date_field) = 4

Thanks