用 to_days() 返回一个天数(从 0 年开始的天数): SELECT user FROM php_jobaccounts where to_days(curdate())-to_days(dateJoined)<=7