# Find dates newer than one week ago SELECT users FROM accounts WHERE created >= DATE_SUB(CURDATE(), INTERVAL 1 WEEK);