php - 今天的 SQL 查询

Question

这个问题已经有答案了:

MySQL Select Date Equal to Today (having datetime as the data type) (5 个回答)

已关闭 6 年前。

$today = date('d/m/Y');

$query = "SELECT * FROM employee WHERE DATE=$today ";

我需要显示具有今天日期的结果。

Answer 1

如果MySQL使用CURDATE()

$query = "SELECT * FROM employee WHERE DATE = CURDATE()";