mySQL 不到一小时

Question

我有一个created_at列作为shares表中的日期时间，life_time列作为状态表中的整数(分钟)。我想找到，

(created_at + life_time - CURDATE()) < 1 HOUR

这是我的sql:

$sql = "SELECT * FROM shares AS s INNER JOIN status AS st ON s.status_id = st.id 
WHERE (s.created_at INTERVAL st.life_time MINUTE - CURDATE()) < 1 HOUR"; 

ERROR : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTERVAL st.life_time MINUTE - CURDATE()) < 1 HOUR LIMIT 0, 25' at line 1

状态表

股份表

Answer 1

使用

WHERE s.created_at INTERVAL st.life_time MINUTE  > NOW() - INTERVAL 1 HOUR;

我确定你必须使用什么>或<