mysql 查询当天的记录

SELECT * FROM your_table WHERE DATE(your_date_column) = CURDATE();

SELECT * FROM your_table WHERE your_date_column >= NOW() - INTERVAL 1 DAY;

SELECT * FROM your_table WHERE your_date_column BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 1 DAY);

SELECT * FROM your_table WHERE DATE_FORMAT(your_date_column, '%Y-%m-%d') = CURDATE();

SELECT * FROM your_table WHERE DATE(your_date_column) = CURDATE() LIMIT 100;

-- 创建示例表
CREATE TABLE example_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    data VARCHAR(255),
    created_at DATETIME
);

-- 插入示例数据
INSERT INTO example_table (data, created_at) VALUES
('Record 1', NOW()),
('Record 2', DATE_ADD(NOW(), INTERVAL -1 DAY)),
('Record 3', DATE_ADD(NOW(), INTERVAL -2 DAY));

-- 查询当天的记录
SELECT * FROM example_table WHERE DATE(created_at) = CURDATE();