select Monthname and year from mysql date format

anyone knows the query of selecting from monthname and year(September 2011) from mysql database DATE format(yyyy-MM-dd)

you could use the this kind of sql query

Select * from table where MONTH(date) = monthnumber and YEAR(date) = year