mysql date and month code example

Example: mysql extract month from date

SELECT MONTH(field_name) as month FROM yourtable