MySql查询出2个字段，在where条件中计算后比较，其中一个字段无法读取到

Question

SELECT a.something,a.time1,a.time2 FROM `table` AS a WHERE a.time1 < (a.time2 * 60 + 3600);

在这种情况下，计算时无法识别到time2，有没有什么好的方法。

Answer 1

SELECT a.id,a.time1 FROM table as a LEFT JOIN (
SELECT id,time2 FROM table
) as b on b.id=a.id WHERE a.time1<(b.time2*60+3600)

Answer 2

SELECT a.something,a.time1,a.time2 FROM `table` AS a having a.time1 < (a.time2 * 60 + 3600);