How to get only today's record in MySQL?

 

How to Use MySQL to Get Records of Today.

You might occasionally need to choose records for today or acquire rows for today. Even though MySQL doesn't have a built-in function for it, getting records from today is fairly simple. This SQL query will retrieve the most recent data from MySQL.

How to Get Records from Today in MySQL

Here are the steps to get records from today in MySQL. Let’s say you have the following table orders(order_date, amount) that contains a list of all orders.

mysql> create table orders(order_date date, sale int);

mysql> insert into orders(order_date, sale)
     values('2020-06-10',250),
     ('2020-06-11',450),
     ('2020-06-12',350),
     ('2020-06-13',220),
     ('2020-06-14',210),
     ('2020-06-15',200);

mysql> select * from orders;
+------------+------+
| order_date | sale |
+------------+------+
| 2022-05-10 |  250 |
| 2022-01-11 |  450 |
| 2022-06-12 |  350 |
| 2022-03-13 |  220 |
| 2022-06-14 |  210 |
| 2022-06-30 |  200 |
+------------+------+

How to Get records from today in MySQL

Here’s the SQL query to get records for today.

mysql> select * from orders
       where date(order_date) = current_date;
+------------+------+
| order_date | sale |
+------------+------+
| 2022-06-30 |  200 |
+------------+------+