select * from user where create_time < (CURDATE()+1) and create_time>CURDATE()
user:表名;
create_time:字段名(存入的时间);
select * from user where create_time < CAST(CURDATE()+1 as date) and create_time>CAST(CURDATE() as date);
两种方式都可以;
select * from user where create_time < (CURDATE()+1) and create_time>CURDATE()
user:表名;
create_time:字段名(存入的时间);
select * from user where create_time < CAST(CURDATE()+1 as date) and create_time>CAST(CURDATE() as date);
两种方式都可以;