select * FROM biaoming WHERE TIMESTAMPDIFF(SECOND ,CREATE_TIME,now() ) > 3*60*60 转载于:https://www.cnblogs.com/angdh/p/10922839.html