How To Get Current Month Records In MySQL

Websolutionstuff | Feb-08-2022 | Categories : MySQL

In this tutorial, we will see how to get current month records in MySQL. For data analysis and reporting, we need more data or records. So, we will learn how to get current month data in MySQL PHP.

For getting data for the current month in MySQL we use the month() function. MySQL month() returns the month number for a given date. The return value is from 1 to 12.

So, let's see SQL query to get current month data, get current month data in laravel 6/7/8, how to get current month data in PHP from MySQL Database.

MySQL Example :

Using SQL query to get data for the current month in MySQL.

id | order_date | amount | Orders
---+------------+--------+-------
 1 | 2022-02-01 | 150    | 2
 2 | 2022-02-02 | 200	 | 4
 3 | 2022-03-03 | 100	 | 1
 4 | 2022-03-04 | 300	 | 5
 5 | 2022-04-05 | 200 	 | 3
 7 | 2022-04-06 | 190	 | 7

 In your table, the record needs to be like date and month.

select * from users
       where MONTH(order_date) = MONTH(now())
       and YEAR(order_date) = YEAR(now());

In the above query, we use the now() function to get the current date, and the month() function to get the current month number of date values. 

 

 

How to Get New Users in the Current Month in MySQL

Using the below MySQL query you can get the new users in the current month with date and count.

select date(created_at), count(*) from users
       where MONTH(created_at) = MONTH(now())
       and YEAR(created_at) = YEAR(now())
       group by date(created_at);

 


You might also like :

Recommended Post
Featured Post
How To Create Custom Middleware In Laravel 9
How To Create Custom Middlewar...

In this article, we will see how to create custom middleware in laravel 9. Laravel middleware provides a conve...

Read More

Mar-27-2022

Date Range Filter In Datatable jQuery Example
Date Range Filter In Datatable...

In this article, we will see the date range filter in the datatable jquery example. Many times we required data of ...

Read More

Nov-14-2022

How To Convert Laravel Query To SQL Query
How To Convert Laravel Query T...

In this article, we will see how to convert a laravel query to an SQL query. Many times we required laravel query builde...

Read More

Oct-27-2022

How To Upload Multiple Image In Laravel 9
How To Upload Multiple Image I...

 In this article, we will see how to upload multiple images in laravel 9. here, we will see the tutorial of multipl...

Read More

Mar-18-2022