PHP Mysql DISTINCT 列当前日期

Question

这个问题已经有答案了:

MySQL compare now() (only date, not time) with a datetime field (2 个回答)

已关闭 3 年前。

只是想让我们区分一列和当前日期的同一时间

表包含 ref，joined 那么现在需要通过 join date = Current date 来缩短

已加入 = 2019-12-21 15:10:53;

$sql = "SELECT DISTINCT ref FROM users where joined = Current date ";

如何编写这个查询可以帮助我们

Answer 1

您可以使用NOW()

$sql = "SELECT DISTINCT ref FROM users where joined = NOW() ";

您也可以使用分组依据

$sql = "SELECT ref FROM users where joined = NOW() group by ref  ";