MySQL 将 DATE 字符串与来自 DATETIME 字段的字符串进行比较
SELECT * FROM shop_count WHERE DATE(count_date)=current_date();
SELECT * FROM shop_count WHERE DATE_FORMAT(count_date, '%Y-%m-%d')=current_date();
- 留言列表
- 发表评论取消回复
-
SELECT * FROM shop_count WHERE DATE(count_date)=current_date();
SELECT * FROM shop_count WHERE DATE_FORMAT(count_date, '%Y-%m-%d')=current_date();