在MySQL查询中使用单位分钟

How do I change 1 hour to 10 minutes in the query below?

如何在下面的查询中更改1小时到10分钟？

$query = "SELECT COUNT(*) as num
  FROM values
 WHERE time >= NOW() - INTERVAL 1 HOUR
   AND ip1 = '$ip1'
   AND ip2 = '$ip2'
   AND submissionid = '$submissionid'";

2 个解决方案

#1

See the documentation for date and time functions.

有关日期和时间功能，请参阅文档。

INTERVAL 10 MINUTE

间隔10分钟

#2

just change INTERVAL 1 HOUR to INTERVAL 10 MINUTE

只需将INTERVAL 1小时更改为INTERVAL 10 MINUTE

#1