mysql，介于和limit之间

mysql , between and limit together

本文关键字：limit 之间 mysql | 更新日期: 2023-12-07

我想获取某个日期间隔之间的所有行，结果集最多为50条记录。查询可以是什么？我在上不断出错

$sql = "SELECT DISTINCT userId FROM ".$TableName.
       " where time BETWEEN (NOW() - INTERVAL "
       .$USER_COUNT_DURATION.
       " MINUTE AND NOW())  LIMIT 0, ".$limit." ;";

看起来像是一个偏执问题。"MINUTE AND NOW（）"应为

$sql = "SELECT DISTINCT userId FROM ".$TableName." where time BETWEEN (NOW() - INTERVAL ".$USER_COUNT_DURATION." MINUTE) AND NOW() LIMIT 0, ".$limit." ;";