CREATE TABLE orders (
id int primary key auto_increment,
type int,
manager_id int,
order_id int,
created_at datetime,
updated_at datetime
);
INSERT INTO orders (type, manager_id, order_id, created_at) VALUES
(1, 6, 2341, NOW());
SELECT * FROM orders WHERE DATE(created_at) = CURRENT_DATE();
SELECT * FROM orders WHERE created_at BETWEEN CURRENT_DATE() AND NOW();