Shulou(Shulou.com)06/01 Report--

How does mysql query today's data? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Mysql queries today's data: [SELECT * FROM `order` WHERE TO_DAYS (order_time) = TO_DAYS (NOW ())].

Build a table:

CREATE TABLE `order `(`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `order_ name` VARCHAR (45) NOT NULL, `order_ time` DATETIME NOT NULL, PRIMARY KEY (`id`))

Query the data of the day (today)

SELECT * FROM `order `WHERE TO_DAYS (order_time) = TO_DAYS (NOW ())

Query yesterday's data

SELECT * FROM `order `WHERE TO_DAYS (NOW ())-TO_DAYS (order_time) = 1

Query the data of the current month (this month)

SELECT * FROM `order` WHERE DATE_FORMAT (order_time,'% Y% m') = DATE_FORMAT (CURDATE (),'% Y% m') Thank you for reading! After reading the above, do you have a general understanding of how mysql queries today's data? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.