php - Get MySQL database entries within last week - Stack Overflow

Sun Jun 21 2020 13:31:54 GMT+0000 (UTC)

Posted by @peota #mys #php

SELECT * FROM tableName WHERE timeColumn > UNIX_TIMESTAMP( date_sub(now(),interval 1 week)) and UserName = 'givenUserName'