SELECT
*
FROM
表名
WHERE
(STR_TO_DATE(日期字段名, '%Y-%m-%d')) = (SELECT
DATE_SUB(curdate(), INTERVAL 0 DAY))
SELECT* FROM 表名 WHERE 日期字段名 = curdate()
SELECT
*
FROM
表名
WHERE
(STR_TO_DATE(日期字段名, '%Y-%m-%d')) = (SELECT
DATE_SUB(curdate(), INTERVAL 0 DAY))
SELECT* FROM 表名 WHERE 日期字段名 = curdate()