mysql 查询出当天数据的sql

mysql 查询出当天数据的sql

SELECT  *
FROM 表名 a
WHERE to_days(a.create_date) = to_days(now()) 

mysql 查询出当天最新数据的sql

SELECT  *
FROM 表名 a
where not exists (
select 1 from dl_xcxq b
where b.create_date > a.create_date
)
AND to_days(a.create_date) = to_days(now())