how to get data of based on month in mysql code example

Example 1: mysql extract month from date

SELECT MONTH(field_name) as month FROM yourtable

Example 2: extract month from date in mysql

MONTH(date)