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
Laravel where and orWhere Condition Example
Laravel where and orWhere Cond...

In this article, we will see laravel where and orWhere condition example. we will give you a very simple example of...

Read More

Jan-11-2021

How To Delete File From Public Folder In Laravel
How To Delete File From Public...

In this article, we will see how to remove/delete files from public folders. We will give you a demo of how to remo...

Read More

Sep-14-2020

7 Tips and Tricks for Laravel Migration
7 Tips and Tricks for Laravel...

As a developer who has been deeply immersed in the Laravel ecosystem, I've come to appreciate the power and flexibil...

Read More

Oct-30-2023

Laravel 8 cURL HTTP Request Example
Laravel 8 cURL HTTP Request Ex...

Hello Friends, Today we will see how to make cURL HTTPs request in your laravel 8 application. This tu...

Read More

Apr-28-2021