请教大家个mysql 时间差比较问题，急，在线等

[etracer]

SELECT wr_endclosing,wr_starting,TIME_TO_SEC( TIMEDIFF(wr_endclosing,wr_starting)) from workrest where wr_driver_tel in (09012312312) and 7200 < TIME_TO_SEC( TIMEDIFF(wr_endclosing,wr_starting)) <10800 and wr_cheduled_actual =1
上面的是我的mysql语句，

---------------------------------------------------------------------------------
wr_endclosing | wr_starting | TIME_TO_SEC( TIMEDIFF(wr_endclosing,wr_starting))
--------------------------------------------------------------------------------
2010-09-09 11:09:09 | 2010-09-09 09:09:09|7200
------------------
根据我的sql语句，应到得不到数据，为什么会得到数据呢？，请指点，我将 7200改成 随便写的数字87847654654654也能得到上面的一条数据，这是为什么呢？

求高手指点

[mysdzlt2007]

7200 < TIME_TO_SEC( TIMEDIFF(wr_endclosing,wr_starting)) <10800这么写？

SELECT wr_endclosing,wr_starting,TIME_TO_SEC( TIMEDIFF(wr_endclosing,wr_starting)) from workrest where wr_driver_tel in (09012312312) and TIME_TO_SEC( TIMEDIFF(wr_endclosing,wr_starting))>7200 AND TIME_TO_SEC( TIMEDIFF(wr_endclosing,wr_starting)) <10800 and wr_cheduled_actual =1

[etracer]

哇，太谢谢你了，哈哈哈，感谢感谢，