MySQL/SQL Queries Fetching Current and Previous Month Data

These queries are for fetching data for the last Months only not the days. :: SQL-Query For Fetching Current Data :: SELECT * FROM table_name WHERE MONTH(field_name) = MONTH(NOW) AND YEAR(field_name) = YEAR(NOW()); :: SQL-Query For Fetching Last One Month Data :: SELECT * FROM table_name WHERE MONTH(created) = (MONTH(CURRENT_DATE)-1); :: SQL-Query For Fetching Previous 3-Months Data :: SELECT * FROM table_name WHERE field_name BETWEEN (CURDATE() - INTERVAL 4 MONTH) AND (CURDATE() - (MONTH(CURRENT_DATE)-1)); <b>:: SQL-Query For Fetching Previous x-Months Data ::</b> SELECT * FROM table_name WHERE field_name BETWEEN (CURDATE() - INTERVAL (x+1) MONTH) AND (CURDATE() - (MONTH(CURRENT_DATE)-1));